Not move cell focus
What I am trying to do is not move focus from cell B30 (when employees are entering tunnel) and M30 (when employees are exiting the tunnel) after the user strikes ENTER.
Is there a way to do this with a formula?
P-217---Tag-In---Tag-Out--1-ver2.xlsm
Is there a way to do this with a formula?
P-217---Tag-In---Tag-Out--1-ver2.xlsm
I'm with FamousMortimer - the sheet as you have it seem to do what you ask using the Worksheet_change code you already have. A macro is the only way to do this - a formula can only return a result to the cell - it can't change focus.
The only other thing I'm aware of you can do is change the 'Excel Options..Advanced...Editin
The only other thing I'm aware of you can do is change the 'Excel Options..Advanced...Editin
ASKER
Sorry for not explaining myself correctly. I am thinks of the end users. They will be miners and will not be educated in the use of computers. They will be going into the mine to excavate material. They are assigned a number during signup and we need to keep track of who is in the mine. I plan on using only a large number pad and hving them "BANG" their number on the key pad to indicate they are in the mine. No mouse will be used.
So, I need the focus or curces to stay in B30 when they are entering their number.
So, I need the focus or curces to stay in B30 when they are entering their number.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
what do you exactly by 'not move focus'. when i enter a number in B30 and press enter, it moves the person to the right and then selects B30 again.
What is the expected behavior?