| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to change move down one cell | Excel Discussion (Misc queries) | |||
| Move cell data to another worksheet cell automatically. | New Users to Excel | |||
| how to move a row to a new worksheet only if a cell has a certain | Excel Discussion (Misc queries) | |||
| How do I move certain Cell data from one worksheet to another? | Excel Worksheet Functions | |||
| Change position of move or copy worksheet option in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
