Tab stops

[TO]

hello All,
I would like to ensure the cursor is active in a text box
when a userform opens.

Is there also a way to loop tab stops. I would like to
use tab stops to get to a particular area of a userform
then keep the tab stops looping through the next section
only. please help.

 

[Tom Ogilvy]

The cursor will be in the control with tabIndex zero.

Set the tabstop property to false for controls you don't want the user to
tab to.

 

[Frank Kabel]

Hi
for the first question use the method
setfocus
of the desired userform element

 

[Tom Ogilvy]

For the initial entry? Why?

 

[Frank Kabel]

Hi Tom
you're correct. No need for that.
Just my personal taste:
- I numer the tab index property starting in the upper left corner
- If I want the focus to be´in a different starting position I use
..setfocus

)

 

[Guest]

Thanks for the help Frank and Tom. I am still having problem getting the
text box activated when the user form opens. If I hit the tab key the
following text box is active, but hte text box it is comming from never
becomes active when the userform is activated. Do I need to use a .activate
or something like that. I must also tell you that i have multiple frames in
the userform. Are the frames the problem? I have a tabstop on the frame and
the text box in the frame and the tab order is 0 in both.

Thanks