ComboBox Data from Column

[pauluk]

Hi People,

Just a quick question,

How do a fill the contents of combox in a vba form with the data contained ion a column, rather then doing .Additem

Thanks in advance

[mangesh_yadav]

Use the ListFillRange property of the combo box, something like this:
ComboBox1.ListFillRange = Range("A1:A10")


- Mangesh

[pauluk]

Tried this solution but it throws up a debugg box,

Help

[mangesh_yadav]

I am sorry, the list fill range property takes a string input, something like this:
ComboBox1.ListFillRange = "Sheet1!A1:A10"


- Mangesh