Tabbing Through a Form
 

Is there a way to set up a form so that your tabs are setup in sequential
order. The places where users will need to tab to jump around a bit, but I'd
like them to be able to fill out the form following the numberical sequence
of the form's cells. I'd also like the cursor to be in the first cell upon
opening the form and after they have finished filling in the final cell, to
have the tab sequence to start over again.

Susan Spencer

Tabbing Through a Form
 

In the "UserForm_Activate" event, you can use the "SetFocus" method to set
the initial focus. For example:

Private Sub UserForm_Activate()
TextBox1.SetFocus
End Sub

With your userform opened, from the "View" menu, choose "Tab order". You can
set the tab order sequence there.

Regards,
Edwin Tam

http://www.vonixx.com



"Susan" wrote:

Is there a way to set up a form so that your tabs are setup in sequential
order. The places where users will need to tab to jump around a bit, but I'd
like them to be able to fill out the form following the numberical sequence
of the form's cells. I'd also like the cursor to be in the first cell upon
opening the form and after they have finished filling in the final cell, to
have the tab sequence to start over again.

Susan Spencer