VBA does not run when cells are in edit mode...
....and in any case why would you want a macro for entering & ?
Tim

wrote in message ups.com...
I want to create some macros that will enter characters in a cell and
leave the active cursor in the cell after those characters are entered.

I want the macro to perform the same way as the custom toolbar charcter
insert buttons for +, *, =. This will allow me to use the macro when
building formulas.

The part I can't figure out is how to leave the cursor active
(blinking) in the cell after the character is entered. For example, I
would like to have macros for entering the " and &.

Thanks for any advice.