I have some user form of option buttons that share the same groupname "optGroup". I would like to enable/disable all option button ins "optGroup" by toggling a checkbox. So far, no working code, but rudimentary idea is:
This doesn't work because optGroup is not a object. So I was wondering is it possible to and how would I reference the the `Enabled` property of each option button in optGroup?
Please Login or Register to view this content.
You could put the option buttons in a frame and then disable/enable the frame, and the option buttons.
Please Login or Register to view this content.
If posting code please use code tags, see here.
But you can treat it like one.Please Login or Register to view this content.
Put this in the user forms code module.
The button will toggle the enabled status of all the option buttons whose group name is "xx"
You can also use code likePlease Login or Register to view this content.
If no option button has the .GroupName "xx" then EnableOptionGroup("xx") will return False. and setting the value of EnableOptionGroup("xx") will have no effect.Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
I did not realize i could do that, I will use this
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks