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

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.