Thread: TextBox focus 3
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Coddington Tim Coddington is offline
external usenet poster
 
Posts: 94
Default TextBox focus 3

Just looking at the from that fails, this is all the code. I found nothing
in the other text box's code to help.


Private Sub OptionButton1_Click()
TextBox1.SetFocus
End Sub

Private Sub OptionButton2_Click()
TextBox1.SetFocus
End Sub

"Bob Phillips" wrote in message
...
show the code on both.

--
HTH

-------

Bob Phillips
"Tim Coddington" wrote in message
...
I have a userform with a textbox on it and several other controlls. I

want
only the text box to have focus so the user can repeatedly input a

number,
press return to process, and enter the next number. On one form I have,
after the return, focus comes back to the text box like it should. On
another form, it leaves to another control. What could be the

difference
between the two forms? I don't see anything in my code that would do

that.