MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Populate ComboBox Manually, not by range

Posted by Wingz on November 07, 2001 12:48 PM

Is there a way to enter your own set of values that a combo box contains, as opposed to using a range? I know thain VB, you make your own "list" of items that the user can select, is there a way to do this for VBA?

Posted by bob Umlas on November 07, 2001 12:51 PM

In a userform:
Me.Combobox1.List = array("Item1","Bananas","Herman")

Posted by Wingz on November 07, 2001 1:01 PM

Sorry to ask but, where does this code go in order to work?