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


--
Dave_2k5
------------------------------------------------------------------------
Dave_2k5's Profile: http://www.excelforum.com/member.php...o&userid=19667
View this thread: http://www.excelforum.com/showthread...hreadid=390183

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


--
HiArt
------------------------------------------------------------------------
HiArt's Profile: http://www.excelforum.com/member.php...o&userid=19953
View this thread: http://www.excelforum.com/showthread...hreadid=390183

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.


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=390183