Excel ComboBox

P

PeteSmith

Is it possible to have a Multiselect ListBox or ComboBox, preferably a multiselect combo on the commandbar.
I am automating from VB.net but functionality should be in Excel Object Model somewhere.

If it is not possible using Excel Object Model can i bring into the excel commandbar a control form VB.net

Yours frustratedly
Pete
 
T

Tom Ogilvy

To the best of my knowledge, commandbars only host their built in controls.

I don't believe the combobox provided supports multiple selections.

Perhaps you could float a modeless userform to accomplish what you want.

--
Regards,
Tom Ogilvy

PeteSmith said:
Is it possible to have a Multiselect ListBox or ComboBox, preferably a
multiselect combo on the commandbar.
I am automating from VB.net but functionality should be in Excel Object Model somewhere.

If it is not possible using Excel Object Model can i bring into the excel
commandbar a control form VB.net
 
Top