Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to run a test on my TextBox which will set my OptionButtons to false
of someone changes the contents of the TextBox and it works fine when they make changes. My problem is that if they click in the TextBox then click some where else on the UserForm the OptionButtons are set to False, even though no change was made to the TextBox. Private Sub TextBox2203_Change() If Me.Visible = False Then Exit Sub Me.TextBox2203 = UCase(Me.TextBox2203.Text) If TextBox2203.Value = rng1(1, 7) Then GoTo Finished End If OptionButton2201.Value = False OptionButton2202.Value = False OptionButton2203.Value = False OptionButton2204.Value = False OptionButton2205.Value = False OptionButton2206.Value = False Finished: TextBox2203.BackColor = &H80000005 End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TextBox in UserForm issue | Excel Programming | |||
Textbox highlighting issue | Excel Programming | |||
textbox issue | Excel Programming | |||
help with textbox change event | Excel Programming | |||
Textbox change event | Excel Programming |