Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set value of checkbox on userform without triggering Click event | Excel Programming | |||
Do not execute Double Click Event when UserForm is Showing | Excel Programming | |||
Click Events on a MultiPage | Excel Programming | |||
userform label double-click goes to click event | Excel Programming | |||
What event to detect click on UserForm ListBox? | Excel Programming |