- Jul 19, 2011
I have a simple worksheet to enter customer Info. I want to control the order of cell selection and reduce the users need to Tab Right.
- User enters First Name, press enter VBA to bounce right and enter Last Name (instead of Tab Right)
- After Last Name is entered, press enter VBA to drop down to address.
- After address is entered, VBA to drop down to City, VBA bounce right for state, VBA bounce right for zip.
- Lastly, drop down to phone number, VBA bounce right for contact name
|FIRST NAME||LAST NAME|