Microsoft Office Forums - View Single Post - Retrieving Rich Text from a RTF Text box in a User Form

Thread: Retrieving Rich Text from a RTF Text box in a User Form

View Single Post

Old

06-19-2014, 11:30 AM

jpb103

jpb103 is offline

jpb103 uses Windows 7 64bit

Windows 7 64bit jpb103 uses Office 2007

jpb103 uses Office 2007

Office 2007

Advanced Beginner

The original poster

Join Date: May 2014

Location: Thunder Bay, Ontario

Posts: 58

jpb103 is on a distinguished road

Default

I get a type mismatch when I try this code.

Code:

        Set oRng = DescriptionBox.TextRTF
        oRow.Cells(1).Range.FormattedText = oRng

Where DescriptionBox is my RTF text box and oRow.Cells(1).Range.Text is where I'd like to put the contents of said RTF text box.

Reply With Quote