Thread: dropdown list/ComboBox

There are a couple of ways to fill your Combobox.

First there is a property called "row source" that needs a range to point it to the data that you want to use in the Combobox. (Easiest)

http://img.photobucket.com/albums/v3...0/Untitled.jpg





Second you can leave the row source blank and use the .AddItem method where you can fill the Combobox each time the UserForm is initiated. (always has the updated info)

....and there is another 3rd way that is escaping me at the moment, maybe one of the other forum members will chime in and jog my memory.


EDIT:can you post an example workbook?, it helps someone like me who isn't all that versed in VBA to figure out what is going on with the problem that you describe.

Take a look at this

Here is yo0ur file with the row source filled in (A1:A5) - see properties window, scroll down to "row source"

Also added some code to your command button to enter the number chosen into cell B1

Try this, I've amended the code to display two columns in the combobox & use the ComboBox's List property

Or you can use the same settings as the first example

Private Sub CommandButton1_Click()
    With Me.ComboBox1
        Range("C1").Value = Cells(.ListIndex + 1, 2).Value
    End With
End Sub