Commandbar dropdown vs combobox, how do I set values

D

Dale Fye

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Commandbar, dropdown vs combobox 1
populate a combobox based on unique values in another workbook 16
populate dropdown/combobox on userform with specific values from s 3
Multi-column Dropdown combox on a commandbar 3
Determine which commandbar called a function 3
Error with combobox control on standard toolbar 1
Problem with SET & REF function 0
Changing the text color on a commandbar button 0

Top