You do rich text formatting with the Characters object.

You can turn on the macro recorder and then do it manually. This will give
you the basic code you need.

--
Regards,
Tom Ogilvy

"Wazooli" wrote in message
...
Actually, maybe I'm being to difficult about this. What I really want is
to
replicate the subscript button from Word. That way, I can subscript
whatever
text might be selected in the cell. Does that make it clearer?

"Tom Ogilvy" wrote:


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" wrote in message
...
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