Tab function

BACHBELL · Feb 26th, 2002, 08:16 AM

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. · Feb 26th, 2002, 08:17 AM

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

Audiojoe · Feb 26th, 2002, 08:17 AM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 08:16 AM	#1
BACHBELL New Member Join Date: Feb 2002 Posts: 3	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

Feb 26th, 2002, 08:17 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Unlock the cells to which you want to tab. Protect the worksheet.

Feb 26th, 2002, 08:17 AM	#3
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	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 ]