thedunna
asked on
automatically tab to next unprotected cell
I am looking for a way to automatically tab to the next unprotected cell after a single number is entered into a cell without using the tab, arrow, or enter keys. Is that possible?
Example: I have multiple rows data. In columns E:M and O:W I would like to enter a single number and advance to the next cell in that row without using the tab, arrow, or enter keys. Everything else in the worksheet is protected with formulas.
Thank you for any help.
Example: I have multiple rows data. In columns E:M and O:W I would like to enter a single number and advance to the next cell in that row without using the tab, arrow, or enter keys. Everything else in the worksheet is protected with formulas.
Thank you for any help.
If you would allow an enter or tab after the digit, then you can accomplish this by selecting the unprotected cells.
You can do this programmatically or manually. You can see this by selecting non-adjacent cells with Ctrl+click and press the Enter key.
The programmatic change of cell activation, based on a digit being typed is a more difficult coding challenge.
Is it possible for you to use a User Form for the data entry process? Using a textbox instead of a cell might provide an easier solution path.
You can do this programmatically or manually. You can see this by selecting non-adjacent cells with Ctrl+click and press the Enter key.
The programmatic change of cell activation, based on a digit being typed is a more difficult coding challenge.
Is it possible for you to use a User Form for the data entry process? Using a textbox instead of a cell might provide an easier solution path.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I can't think of a way to do exactly what you describe. As a possible workaround, please see the attached. Key in a string of digits to A1. Then hit Enter (sorry!). At this point, the individual digits are output to range B1:B20. (I picked 20 arbitrarily - no reason why it shouldn't be more. BTW, if you enter more than 20 digits then the excess is dumped into B21.)
Assuming that the above isn't acceptable, please give us some background as to what you'll be doing and why.
Thanks,
Brian.