I don't think that this is possible in excel.

Are you saying you could format the font character by character in one of the
controls of your userform? (I don't think I've ever seen that. How did you do
it?)



Ligaya wrote:

To all,

I have been importing text with special characters from spreadsheet to
userform and visa versa. The problem is that when I export/import, the text
format is not carried.

Examples of special character with in the text are supercripts and
subscripts.

--

Dave Peterson