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

jpb103 · #1 06-19-2014, 12:33 PM

Code:

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

Code:

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

These two code segments perform exactly the same operation. Setting oRng is redundant to the logic.

Cosmo · #2 06-19-2014, 12:41 PM

Quote:

Originally Posted by jpb103

Code:

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

Code:

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

These two code segments perform exactly the same operation. Setting oRng is redundant to the logic.

DescriptionBox.TextRTF is a String
oRng is a Range

The first cannot work, as you cannot set a range variable to a string.

The second might work, assuming that the .Range.FormattedText accepts a string of formatted text (which is what you see).

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Rich text/Plain text Content Controls in Template	michael.fisher5	Word	9	11-19-2014 06:36 AM
Rich Text Content Control - Allow User Formatting	keithacochrane	Word	1	05-28-2012 05:06 PM
How to I make text Bold in a User Form -Visual Basic	gurp99	Word VBA	11	03-12-2012 04:05 PM
My plain text post got converted to rich text in a reply, how to convert it back?	david.karr	Outlook	0	01-05-2012 09:46 AM
Templates: automatic text generation from Rich Text content control	Chickenmunga	Word	0	10-01-2008 11:16 AM