Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following code is not consistent; The focus is set ONLY the FIRST TIME I
activate the Worksheet - If I lease WS (Deactivate - UserForm1.hide) and return to WS (Below) my textbox1 DOES NOT GET THE FOCUS.. What am I missing? Private Sub Worksheet_Activate() With UserForm1 .TextBox1.Value = "" .TextBox2.Value = "" .TextBox3.Value = "" .Show vbModeless .TextBox1.SetFocus ' This line not being consistent End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you SETFOCUS on TextBox | Excel Programming | |||
Having problems with textbox setfocus | Excel Programming | |||
setfocus in textbox on multipage | Excel Programming | |||
SetFocus to first textbox on userform upon Userform1.Show | Excel Programming | |||
TextBox.SetFocus | Excel Programming |