View Full Version : keep text formating when transfering text from text box to cell

11-12-2007, 08:45 AM

I have a sheet in which the user types information into a text box on a worksheet, and some of that text will be formatted in bold and some of the text won't be. I then need to transfer that text into either another cell in the worksheet or into another text box and I need to keep the same formatting, i.e. any text that was in bold needs to stay in bold.

Any help would be much appreciated

Bob Phillips
11-12-2007, 09:14 AM
I think you would have to parse it character by character and extract the format.