HELP - Tabbing Between Items

[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 3 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 is '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 of optionbuttons, tab again will goto the next group of optionbuttons and so on!!!!

How can I achive this???

Cheers,

Dave

[HiArt]

if you click on the object in the Form, and use have the properties Window open (press F4 if not), towards the bottom there is a TabIndex property. Set to 1 for the 1st object, click the next object and set to 2, etc. Also make sure TabStop is set to true.

Art

[funkymonkUK]

Easier user friendly way.

In VBE click on your form then click View then Tab order and then use the buttons on the right hand side to move the items up or down.

If you have frames then you will need to click on the fram and do the same but on your main form make sure the frame is in the correct order.