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?