Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enabling more than one option button
Hi all,
Once again thanks for all the help. My next problem is that i have 3 frames and each frame has about 6 option buttons in. The problem is that i would like to have a reset button that will reset all option button at once. Would one have to put under the reset button OptionButton_905.enabled = True For each option button or is there shorter code that will do them all ? Tempy *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enabling more than one option button
Dim cntrl as control
for each cntrl in Userform1.controls if typeof cntrl is MSforms.OptionButton cntrl.Value = False end if Next -- Regards, Tom Ogilvy "Tempy" wrote in message ... Hi all, Once again thanks for all the help. My next problem is that i have 3 frames and each frame has about 6 option buttons in. The problem is that i would like to have a reset button that will reset all option button at once. Would one have to put under the reset button OptionButton_905.enabled = True For each option button or is there shorter code that will do them all ? Tempy *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enabling more than one option button
18 buttons is not that many when you copy and paste, and then just change
the number. -- HTH RP (remove nothere from the email address if mailing direct) "Tempy" wrote in message ... Hi all, Once again thanks for all the help. My next problem is that i have 3 frames and each frame has about 6 option buttons in. The problem is that i would like to have a reset button that will reset all option button at once. Would one have to put under the reset button OptionButton_905.enabled = True For each option button or is there shorter code that will do them all ? Tempy *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enabling more than one option button
Thanks so much Thom,
Have a great weekend, i am almost outa here !! It is 15:50 here. Tempy *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling voting button | Excel Discussion (Misc queries) | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Disabling/enabling events with a button created by code?? | Excel Programming | |||
Conditional Button Enabling based on Checkbox | Excel Programming | |||
Button Enabling based on check in checkbox | Excel Programming |