View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_4_] Steve[_4_] is offline
external usenet poster
 
Posts: 184
Default Click event for UserForm Multipage

Hi everyone. I have a User Form Multipage with 2 tabs on it. I need the focus to be set on the first tab upon initialization. On the second tab I have a text box. I am trying to create a click event that when the user clicks tab 2, the default field in the text box becomes highlighted so the user can simply type over without deleting the default value.
The code I have is as follows:

Private Sub MultiPage1_Click(1)
With UserForm1.TextBox1
.SetFocus
.SelStart = 0
.SelLength = Len(.Text)
End With
End Sub

But I get a Compile error, expected identifier. Any thoughts?

Thanks!