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

"Frank Kabel" wrote:

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

:-))

--
Regards
Frank Kabel
Frankfurt, Germany

"Tom Ogilvy" schrieb im Newsbeitrag
...
For the initial entry? Why?

--
Regards,
Tom Ogilvy

"Frank Kabel" wrote in message
...
Hi
for the first question use the method
setfocus
of the desired userform element

--
Regards
Frank Kabel
Frankfurt, Germany

"TO" schrieb im Newsbeitrag
...
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.