Dropdown List In Form

[HarryT]

I am trying to create a dropdown list in a form. I created the form and added the ComboBox but can't figure out how to add values for the enduser to choose.

Any suggestions?

Thanks

 

[VoG]

You can set the RowSource property.

 

[HarryT]

Hi, what is wrong with this code? I want the box to show "Blue" in the dropdown.

Private Sub ComboBox1_Change()
ComboBox1.RowSource "Blue"
End Sub

Thanks again!

 

[VoG]

Maybe

Private Sub ComboBox1_Change()
ComboBox1.AddItem "Blue"
End Sub

But adding Blue would be better done vin the UserForm_Initialize code I think.

 

[HarryT]

Thanks, but nothing I am trying is working. Is it possible to drive the dropdown in a form from a list in the spreadsheet itself? Such as Range ("A1:A3"). I tried this as well and it doesn't work. In range A1-A3 I have colors listed... Blue, Red, Black

Private Sub ComboBox1_Change()
ComboBox1.RowSource = Range("A1:A3")
End Sub

Doesn't seem like it should be this difficult. I am not familiar with the UserForm_Initialize code.

Thanks

 

[VoG]

Try like this

Private Sub ComboBox1_Change()
ComboBox1.RowSource = "A1:A3"
End Sub

 

[HarryT]

Nope, I have tried RowSource, AddItem both numerous ways. Can't seem to find the right combination.

 

[VoG]

This works for me

Private Sub UserForm_Initialize()
ComboBox1.RowSource = "A1:A3"
End Sub

When you display the userform you will need to click the dropdown arrow to see the list.

 

[HarryT]

Thank you so much, it did work. I never worked with the 'Initialize' function before.