Geek Answers Handbook

Can I add a combo box to a column in a list in VBA?

Using a VBA form, can I add a Listbox control with columns that contain Combo controls? enter image description here

+7
vba excel-vba forms combobox listbox
source share
2 answers

Unable to use Standard VBA ; Standard VBA will not allow this! You can create a custom ActivX control or load another third-party control, as suggested elsewhere, but the standard ListBox cannot contain a ComboBox .

Other methods may be used if you can provide more details ...

+1
source share

If you insist on this using User Forms, the only way is that when you click on the list item, it must expose another form containing the combo box, it will be too much work to create and complex work.

I am sure that with the spreadsheet itself you can find the best solutions. I'm still not sure what you ultimately want to achieve, but for me it's just a dependent list, so you can use sth like this in the spreadsheet itself:

http://www.contextures.com/xlDataVal02.html

0
source share

More articles:


All Articles