marchristensen
MIS
I want to create an Excel macro that allows me to enter a number in a cell, press <Enter> and jump to the adjacent cell. The number I will be entering will be different time. How can I do this.
Thanks
Thanks
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
EXCEL 2000 MACRO WITH VARIABLE ENTRY
- Thread starter marchristensen
- Start date
- Status
JVFriederick
IS-IT--Management
How about setting Tools Options Edit, then move selection after entry ?
- Thread starter
- #3
marchristensen
MIS
Many thanks for the quick response. Changing Tools Option Edit and Move After Entry will work fine BUT after making three of these entries I want to move to the beginning of the next row automatically. I am trying to do this with a macro. Another wrinkle is that there are a variable number of rows using this macro. One day it may be 100 rows and another day 200. Any help is much appreciated.
Regards
Lynn C
Regards
Lynn C
JVFriederick
IS-IT--Management
No problem. Hightlight a range, say A10:C50.
Now start typing away. Excel will automatically wrap to the next row.
Now start typing away. Excel will automatically wrap to the next row.
- Status
