blackie42
09-17-2009, 04:14 AM
Hi
Am wondering if embedded optionbuttons can be part of a sub dependent on their state.
I have a couple on a sheet and am using the following routine
Sub query()
If OptionButton1.Enabled = True And Range("V28").Value < 0 Then
UserForm1.Show
End If
End Sub
But regardless of the value of V28 or optionbutton selected the userform still displays.
Any help appreciated
thanks
Am wondering if embedded optionbuttons can be part of a sub dependent on their state.
I have a couple on a sheet and am using the following routine
Sub query()
If OptionButton1.Enabled = True And Range("V28").Value < 0 Then
UserForm1.Show
End If
End Sub
But regardless of the value of V28 or optionbutton selected the userform still displays.
Any help appreciated
thanks