Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello, I posted this same question in another discussion group, but I
actually meant to post it on this one. My question is: Why doesnt this work. I know it works for a check box but I dont know how to make it to do the same function using the option buttons. Private Sub OptionButton1_Click() Me.TextBox1.Enabled = Not Me.OptionButton1.Value Me.TextBox2.Enabled = Not Me.OptionButton1.Value End Sub |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If you're clicking on the optionbutton, aren't you always turning it on?
Maybe using Private Sub OptionButton1_Change() would be better. N.F wrote: Hello, I posted this same question in another discussion group, but I actually meant to post it on this one. My question is: Why doesnt this work. I know it works for a check box but I dont know how to make it to do the same function using the option buttons. Private Sub OptionButton1_Click() Me.TextBox1.Enabled = Not Me.OptionButton1.Value Me.TextBox2.Enabled = Not Me.OptionButton1.Value End Sub -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Not sure but you probably need to add another option button
"N.F" wrote: Hello, I posted this same question in another discussion group, but I actually meant to post it on this one. My question is: Why doesnt this work. I know it works for a check box but I dont know how to make it to do the same function using the option buttons. Private Sub OptionButton1_Click() Me.TextBox1.Enabled = Not Me.OptionButton1.Value Me.TextBox2.Enabled = Not Me.OptionButton1.Value End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
need help on how to grey out one option button in one group box based on the selection of another option button in another group box | Excel Programming | |||
Option Button | New Users to Excel | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
option button? | Excel Programming | |||
Option button help | Excel Programming |