View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick C. Simonds Patrick C. Simonds is offline
external usenet poster
 
Posts: 343
Default TextBox change issue

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