set focus...is it really this difficult?

[RAYLWARD102]

I've run into this before and it drives me nuts! I have a userform with many textboxes, buttons and labels on it.
If I select all of these objects and set the tab stop to "false", and then only click on textbox1 and select tab stop = "true"; shouldn't i be able to add a line to the ending code of every button like, "textbox1.setfocus" to return the focus to the textbox1 field?
Apparently not! This blows me away!

 

[RAYLWARD102]

i'm gonna snap!

 

[Smitty]

I generally use:

<font face=Calibri>    <SPAN style="color:#00007F">With</SPAN> Me.TextBox1<br>        .SetFocus<br>        .SelStart = 0<br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

HTH,

 

[RAYLWARD102]

tried it. No go!
It doesn't show the cursor.

 

[Rasm]

That works - try to type away - maybe you have some other code that moves it after you setfocus - so if you type you can see where your cursor migrated to.

 

[Smitty]

Is there some other event taking precedence?

 

[Norie]

I generally avoid SetFocus, because invariably it doesn't work - kind of like SendKeys I suppose.

Using it get's particularly flaky when you involve frames, multitabs etc.

What is it you are trying to do?