Is there a way to pause a macro in a Excel Spredsheet so that the user running the macro can enter data and then by hitting the enter key be taken to another cell set by that macro, and so on. I want the macro to visit several cells within the spredsheet, but I wnat the macro to take the user to the pre-determined cell and pause for the enter key to go to the next cell until the macro is done... Thanks I really need help.....
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excell 2000 Macros
- Thread starter Jonny5
- Start date
Similar threads
