PC Review


Reply
Thread Tools Rate Thread

Commandbar dropdown vs combobox, how do I set values

 
 
=?Utf-8?B?RGFsZSBGeWU=?=
Guest
Posts: n/a
 
      22nd Oct 2007
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
populate dropdown/combobox on userform with specific values from s sam Microsoft Excel Programming 3 18th Sep 2009 12:31 AM
Multi-column Dropdown combox on a commandbar Chris Wilkinson Microsoft Excel Programming 3 15th Sep 2008 04:49 PM
Custom Commandbar, dropdown vs combobox =?Utf-8?B?RGFsZSBGeWU=?= Microsoft Excel Programming 1 24th Oct 2007 07:26 PM
Bug: Combobox.dropdown = True during Form.New() causes listbox to be disabled, even though combobox is Enabled. =?Utf-8?B?UmF0a2lsZXk=?= Microsoft Dot NET Framework Forms 1 12th Feb 2004 09:58 PM
Value of ComboBox on Custom CommandBar Kevin Microsoft Excel Programming 4 15th Jan 2004 10:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:02 PM.