Hi all,

Sorry. My first post just got posted without finishing the whole story.

I have been exporting and importing text from spreadsheet to userform and
vise versa. The problem is that it does not take the special format such as
subscripts and superscripts.

Example SO4(subscript) 2- (superscript)

Is there a way that the formatting be retained when exporting/importing?

Thanks.

Ligaya