View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Larry Sartoris
 
Posts: n/a
Default buttons and boxes in userform

Thanks so much for your reply and help. I just have one more question. That
worked beautifully, but what if I wanted to enter 2 numbers into the textbox?

Thanks so much!

"Anita" wrote:

Hi Larry,

Try something like this:

Private Sub TextBox1_Change()
TextBox2.SetFocus
End Sub

For any change to the text in textbox1, textbox2 gets the focus.