help help help with cell navigation

dodgy99uk

New Member
Joined
Sep 8, 2002
Messages
1
I have justs tarted to create forms and i have created a sheet and it has 8 cells which i want to navigate if i am in for instance forename and i want to move = on pressing enter - to the surname cell - which is niether below or next in any way - how do i tell my sheet to do this ????

please help me i am newbie

Roger
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
First, select the cells where data can be entered and Choose Format>Cells. On the Protection Tab, deselect the "Locked" option. Click OK. Now Go to Tools>Protection and protect the worksheet. Now when you use the TAB key, Excel will move to the next "Unlocked" Cell. If this isn't sufficient for your needs, you will have to use VBA coding and a change event.
 

Forum statistics

Threads
1,143,641
Messages
5,719,988
Members
422,257
Latest member
Calion

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
Top