setting tabStop within userForm

[bstubbs]

Howdy, folks:

I have a userForm and I use a load, set the field defaults and show sequence to use the form. I want to be able to set the initial field (a "setFocus" didn't work) and then how pressing the tab will move through the fields. How can I do this?

TIA.

Bob

[dominicb]

Good morning bstubbs

I have a userForm and I use a load, set the field defaults and show sequence to use the form. I want to be able to set the initial field (a "setFocus" didn't work) and then how pressing the tab will move through the fields. How can I do this?

From the VBE, with your userform design on the screen, go to View > Tab Order, and set the order in which the user is to be able to cycle through the controls.

HTH

DominicB

[bstubbs]

Thanks - exactly what I needed!

Bob