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