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.

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.

--
Regards,
Tom Ogilvy



"TO" wrote in message
...
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.

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.

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.

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.

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.