Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBox_Change() problem
On my UserForm is TextBox1, which if a user makes a change to the TextBox I
want the value of some OptionButtons set to false. That in its self is easy enough, using the TextBox1_Change routine below. My problem is that during UserForm Initialization TextBox1 is populated with the following code: TextBox1.Value = rng(1, 7).Text Unfortunately the TextBox1_Change routine sees that as a change and sets all OptionButtons to False. Any suggestions? Private Sub TextBox1_Change() Me.TextBox1 = UCase(Me.TextBox1.Text) OptionButton1.Value = False OptionButton2.Value = False OptionButton3.Value = False OptionButton4.Value = False OptionButton5.Value = False OptionButton6.Value = False End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
suspend processing for TextBox_Change events when initializing a f | Excel Programming | |||
TextBox_Change a little premature! | Excel Programming | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |