MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combo Boxes and VBA

Posted by Michael on December 17, 2001 1:47 PM

How do I define a variable in a macro to equal the text that someone selects from a combo box on the main spreadsheet?

Posted by Juan Pablo G. on December 17, 2001 8:11 PM

Well, that depends. If it's a Form commandbar you would need to link your variable to the linked cell of the combobox, something like

YourVar = Range("A1")

If A1 is the linked cell of the Combo Box. If you're working with one of the Control Toolbox toolbar then you could use (If you really want a variable to do this)

YourVar = ComboBox1

or to get the Number (From 0 to ListCount - 1) of the selected item

YourVar = ComboBox1.ListIndex

If it returns -1 then nothing is selected.

Juan Pablo G.