On Wed, 20 Apr 2011 18:18:18 -0400, Phrank wrote:

Hi and thanks! I did some more searching online during lunch today
and came across the code below which works absolutely great! I placed
it in the Worksheet_Change event also, and all I have to do is enter a
^ (shift 6) character before the letter i want to superscript or a |
(shift back slash) before the letter I want to subscript. Once I hit
enter, my letter is formatted appropriately. Now, this only works
with a single character,

Also, your string needs to not be all numbers. I'm glad you found something that works for you.