Leave live cursor in a cell?
 

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.

Leave live cursor in a cell?
 

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.

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.