User Form/Combo Box

[Glenn]

Hi,

I am making a user form in visual basic on excel, I have
put a combo box on the form but am unsure how to programe
it so that when the arrow is selected it will reveal all
the options available for the user to choose.

 

[Jason Morin]

If you're in the Visual Basic Editor, right-click on the
combobox and select Properties. Find the "Row Source" and
enter the range that contains your list (e.g., Sheet1!
A1:A5).

HTH
Jason
Atlanta, GA

 

[Harald Staff]

Or the code way (do not use this if you link it to a range with Row source):

Private Sub UserForm_Initialize()
With ComboBox1
.AddItem "Too cheap"
.AddItem "Good deal"
.AddItem "OK"
.AddItem "Expensive enough"
.AddItem "Keep on dreaming"
End With
End Sub