Hello,
I have attached an example workbook; hopefully this is a simple fix.
You will find three frames each with multiple option buttons.
I would like to be able to select multiple option buttons within each frame.
Thanks you for all of the help!![]()
Hello,
I have attached an example workbook; hopefully this is a simple fix.
You will find three frames each with multiple option buttons.
I would like to be able to select multiple option buttons within each frame.
Thanks you for all of the help!![]()
Someone just suggested I use checkboxes not optionbuttons?
Any thoughts on this?
I think you mean you want to select one option button within each frame.
The OptionButton has a property called GroupName. This determines what group the option button is in. Only one button in a group can be selected at a time.
Decide on a GroupName to use for the buttons in each frame, and then update that property in each button (click the button then press F4 to get the list of properties).
This post is incorrect. When option buttons are in frames, they automatically are associated in a group without having to set GroupName. So I misunderstood your question.
Last edited by 6StringJazzer; 05-20-2015 at 11:31 AM. Reason: as shown
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Thanks but I do want to be able to select more than one option button within the frame. Its seems that my approach was incorrect and I need to use a different function other than an option button.
I am still a rookie trying to learn how to create userforms.
Thanks.
Yes, you should use checkboxes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks