Starting Point For Form

**markrennolds** · 03-23-2010, 04:53 PM

Hi All

I have the following code for a user form that works fine, however I am new to userforms & cannot find how to get the cursor to start in the text box that i want, and after the user has submitted the data for it to return to this point. I know its probably being very daft of me but i cannot get the code correct.
The text box I want as starter point is called TextBoxSurname

The code at moment is:

Please Login or Register  to view this content.

cheers
Mark

**royUK** · 03-23-2010, 04:57 PM

Take a look at SetFocus

Please Login or Register  to view this content.

**kym1901** · 03-23-2010, 04:58 PM

Each input box on the form has a property called "TabIndex" Set these numerically and you should be able to tab through the form from 1 to 11 (or whatever). When the form reloads the cursor should be at the box set as TabIndex1.
It works for me and I've built a few forms.

As I'm new there might be a better way to do this, good luck.

**contaminated** · 03-23-2010, 04:59 PM

Try this

TextBoxSurname.SetFocus

**dominicb** · 03-23-2010, 05:00 PM

Good evening markrennolds

From the VBE, with your userform selected, simply go to View > Tab Order.
A small dialog will poen listing all your controls - just use the buttons to move them up or down until they're in the order that you want. Then whenever a user tabs through your controls, this is the order they'll follow.

You can also alter the TabIndex property from the properties box, but the above way is miles easier / better / faster etc.

HTH

DominicB