Top suggestions for i have two vba codes under workheet_change byval target as range for the same worksheet that does two steps how do i combine the steps under one private sub code. the first code changes the first letter of a2 and b2 to uppercase and keeps rest of letters lowercase if not typed that way and the second code moves my cursor from the first defined entry cell to the next entry cell in order of entry when tab or enter is pressed, order of entry is cell A2 for last name entry, b2 for first name entry, c2 for date of birth, and e2 for date of service and after e2 is populated and tab or enter is pressed the cursor moves to I2 and ends there
Explore more searches like i have two vba codes under workheet_change byval target as range for the same worksheet that does two steps how do i combine the steps under one private sub code. the first code changes the first letter of a2 and b2 to uppercase and keeps rest of letters lowercase if not typed that way and the second code moves my cursor from the first defined entry cell to the next entry cell in order of entry when tab or enter is pressed, order of entry is cell A2 for last name entry, b2 for first name entry, c2 for date of birth, and e2 for date of service and after e2 is populated and tab or enter is pressed the cursor moves to I2 and ends there