Leave live cursor in a cell?
Microsoft includes toolbar buttons for +, -, /,= which at times I use
to build formulas by just clicking on them. I want to add to these and
the quotes sign " and & are used a lot when concatenating in a formula.
Tim Williams wrote:
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.
|