Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Totally new to macros and VBA, but may need then to accomplish a task.
Need to direct data entry into specific cell locations in Excel 2000. Already have unlocked cells and protected worksheet. Need to find a way to do something like this: go to B2 on open sheet accept data entry Go to C4, accept data Go to E4, accept input and so and so on I used the record macro process, but I can't find a way to cause the macro to pause for input, between the go to commands. Therefore the result is that It goes straight to the ending location! I know it's do-able, just don't understand how! Any and all pointers appreciated! Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
move from active cell offset in macro | Excel Discussion (Misc queries) | |||
Move active cell to same location on each worksheet | Excel Discussion (Misc queries) | |||
Can a cell be set to accept input only once? | Excel Worksheet Functions | |||
Input mask for active cell | Excel Discussion (Misc queries) | |||
need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) |