View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SFC Traver SFC Traver is offline
external usenet poster
 
Posts: 14
Default Worksheet change: move to next cell

I have browsed around the group and didn't find anything specific to help me
with a macro. I am weak on VBA. What I need is when a single digit value is
entered in a cell, to have it move to the next cell. So, when a user types in
"4" in B2, then it should move to C2.

I also need it to move to the next row once it a value is entered in Y2. So
when a user types in "3" in Y2, it moves to B3 and repeats the code above.

Can it be done? I've done the data validation to restrict the cells, just
need specifics on how to do the macro.
Thanks!