How can I get the cursor to move right upon inserting a digit from 1 to 9 in a cell using VBA without having to press enter or return

How can I get the cursor to move right upon inserting a digit from
1 to 9 in a cell using VBA without having to press enter or return

VBA will not executive while in EditMode on a worksheet. You have to
manually exit EditMode to fire an event. This requires a keypress
(Enter, Tab, right arrow, Esc) IOW, I'm pretty sure what you want to do
isn't possible.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Excel doesn't know you have entered something in a cell until you
indicate you are finished with that cell by hitting Enter or hit an
arrow key(if not in edit mode)

Use rightarrow to move right when ready to go.

Gord

On Thu, 14 Mar 2013 20:09:23 +0000, Michel Gauthier
wrote:


How can I get the cursor to move right upon inserting a digit from 1
to 9 in a cell using VBA without having to press enter or return

Do you want this behavior to occur for all cells or only certain cells?