Macros don't run when you are in Edit mode. At least not in anyway that
they can be used to subscript the current character you are entering.

Whether you can enter a formula directly in a cell is controlled in
Tools=>Options=>Edit tab.

--
Regards,
Tom Ogilvy



"Wazooli" <Wazooli@discussions.microsoft.com> wrote in message
news:3CD06305-98E0-47F7-9569-4223791EFB4A@microsoft.com...
> Which object controls the ability to type in either the formula bar or
> directly in a cell? Specifically, how can I get the text selection so I
can
> superscript or subscript it? As an example, instead of H2O, I would like
the
> 2 to be subscripted. I know how to do this via format cells, but I would
> like to do it in code so I can assign a toolbar button to it.
>
> wazooli