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 *** |
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 *** |
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 *** |
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 *** |
All times are GMT +1. The time now is 08:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com