Commandbar dropdown vs combobox, how do I set values
 

What is the difference between an msoControlDropDown and msoControlCombobox?

I've created an Options commandbar, and wanted to add checkbox controls to
it to allow users to set some Yes/No default values. It appears that
checkboxes are not allowed in Excel commandbars, so I want to use a combobox
or dropdown, which I have done.

Now, I need to know how to programmatically set the "default" values of
these controls, and determine how to read the values that have been selected.
I will probably set some "global variables" and refer to when these within
my code, but am not sure how to get the values in the first place.

Thanks for your help
--
Don''t forget to rate the post if it was helpful!

Email address is not valid.
Please reply to newsgroup only.