Tab function

[BACHBELL]

We have a very simple Excel question/problem. We are developing a form here at work. What we would like to do is have the 'user' hit the tab key and it go to the next cell that needs to be completed.

Can this be done without running any Macros? If not what would the VBA code be?

Thanks for any help/suggestions,
BACHBELL

 

[Mark W.]

Unlock the cells to which you want to tab. Protect the worksheet.

 

[Audiojoe]

Sorry, got there too late!

Hi,

You can select the cells you want to tab between and format them to be unlocked, then protect the sheet.

Now when you press tab you'll only go between those cells

Regards
This message was edited by Audiojoe on 2002-02-26 07:18