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

Cosmo · 06-19-2014, 12:18 PM

Quote:

Originally Posted by jpb103

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.

This might work:

Code:

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