Cursor control in forms

[smccain1960]

I have created a userform to collect name and address information. The form consists of the following text boxes: name, st_add1, st_add2, st_add3, city, state, & zip.

If the user tabs out of any of the st_add text boxes, leaving it empty I want to place the cursor in the city text box. For example, if the user tabs out of st_add1, leaving it empty, I want to place the cursor in the city text box.

How do I accomplish this task? Setfocus will only skip one text box at a time.

I am using Excel 2007

 

[TFCJamieFay]

Try playing around with the TabStop property. This will allow you to control where the cursor goes when tab is used.

HTH Jay