OptionButton & CheckBox
Hello Experts,
I have added a few OptionButton's & CheckBoxes to my UserForm in Outlook - but they're different then dropdown boxes (which I am familiar with). I am hoping for someone to post example VBA code, showing me how I interact with an OptionButton & Checkbox - and store the values in variables.
Example:
OptionButton = Choices "Yes" & "No".
I assume one variable, would hold the answer to the OptionButton.
CheckBoxes = "Apple" & "Bread" & "Cheese"
And I assume CheckBoxes would involve multiple variables?
I'm pretty confused.
Thank you in advance for your help!
~ Geekamo
I have added a few OptionButton's & CheckBoxes to my UserForm in Outlook - but they're different then dropdown boxes (which I am familiar with). I am hoping for someone to post example VBA code, showing me how I interact with an OptionButton & Checkbox - and store the values in variables.
Example:
OptionButton = Choices "Yes" & "No".
I assume one variable, would hold the answer to the OptionButton.
CheckBoxes = "Apple" & "Bread" & "Cheese"
And I assume CheckBoxes would involve multiple variables?
I'm pretty confused.
Thank you in advance for your help!
~ Geekamo
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Martin Liss
And normally Option Buttons (which are also called radio Buttons) are used to present the user which a small number of mutually exclusive choices. I say a small number because if there more than two or three, a listbox or combobox is the normal solution. Checkboxes on the other hand are used to present the user with a small number of non-mutually exclusive choices but again if there's more than a few, a listbox or combobox is the normal solution.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.