HELP - Tabbing Between Items

  • Thread starter Thread starter Dave_2k5
  • Start date Start date
D

Dave_2k5

I have a questionnaire I am working on in excel.

There are 24 questions in all.

I have, 7 text boxes for open answers, 14 groups of optionbuttons and
validation cells, which has a 'Yes' 'No' list.

What I want to do is to be able to start at the first text box which i
'name', then when the tab button is press it will go to 'department
(the text text box) then hitting tab again will goto the first group o
optionbuttons, tab again will goto the next group of optionbuttons an
so on!!!!

How can I achive this???

Cheers,

Dave :confused
 
When I only want to tab to certain areas, I format a locating cell in each
area as UNLOCKED. Use the right mouse, select format cells, go to the last
tab, and take the check mark off of Locked.

After you format the cells, you will need to protect the workbook to make
changes take affect by using the Tools menu, Protection, Protect Sheet.

The only problem is that when the sheet is protected, I don't know if your
option buttons will work unless you can also format them as unlocked.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP - Tabbing Between Items 2
How to use ENTER in a TextBox in Excel 2007 2
TextBox change issue 1
Calculating option buttons on a Word 2007 form 3
Tabbing between text boxes in Excel 2007 1
Tabbing through Text Boxes in Excel 2002 1
Tabing in user form 5
Auto select worksheets - and goto a specific cell afterwards 2

Back
Top