In most cases we want to insert the symbol after the text. What we really
want is the ability to press 1 key and insert the symbol before or after the
text.

"Gary''s Student" wrote:

A symbol is just a character in a special font. Do you want the symbol to
replace the text in the cell or precede the text in the cell or follow the
text in the cell?
--
Gary's Student


"Frank E" wrote:

I have created a macro that inserts a symbol into the active cell. If I have
entered text in a cell and try to use my macro it won't work. What code do I
need in my macro to enable me to insert my symbol while entering text?