Hi
Excel 2016 VBA Macro question
I want to create a Macro Button that controls the movement of my cursor (between entering data) and a 2nd macro.
Example
Start Macro (in any field)
Wait till a value is entered into a field (enter)
Move Left. Wait till a value to the field (enter)
Move Left. Wait till a value to the field (enter)
Move Left. Wait till a value to the field (enter)
Move Left. Wait till a value to the field (enter)
Move Down
Move Right
Move Right
Move Right
Move Right
Repeat.
Move from C5 to D5 to E5 to F5
Move to C6
Stop macro
Thanks
E.W.
Excel 2016 VBA Macro question
I want to create a Macro Button that controls the movement of my cursor (between entering data) and a 2nd macro.
Example
Start Macro (in any field)
Wait till a value is entered into a field (enter)
Move Left. Wait till a value to the field (enter)
Move Left. Wait till a value to the field (enter)
Move Left. Wait till a value to the field (enter)
Move Left. Wait till a value to the field (enter)
Move Down
Move Right
Move Right
Move Right
Move Right
Repeat.
Move from C5 to D5 to E5 to F5
Move to C6
Stop macro
Thanks
E.W.