Move Selection after Enter

purplelily

New Member
Joined
Sep 25, 2005
Messages
23
I am using Excel to create a form. I unlocked some cells that users will need to input data and protected the sheet.
I am trying to find out how I can move the selection after enter. In know in Option>Edit, I can determine the direction. But what if I want to designate the cell to move after enter?
Say from A1, <ENTER>, to go to D8.

Possible?
Many thanks!

pearlie
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Why not protect the sheet being sure to uncheck the "Select locked cells" before clicking OK? That will cause the selection to only move among unlocked cells.
 
Upvote 0
Thanks for the suggestion. (sorry for the late reply... )
However, it did not really work, the movement of cell was erratic -
with the way the form was designed in Excel, with merges and all.
I suppose the lesson might be that Excel is not the best tool to use for forms :)
But still, many thanks!
pearlie
 
Upvote 0
Use Tazguy's recommendation and then use both Enter, Tab and the arrow keys to move in the form.
 
Upvote 0

Forum statistics

Threads
1,226,723
Messages
6,192,681
Members
453,745
Latest member
fueled_vba

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top