Populatng a combobox from a column of a Excel Table

[jgunders]

Hi Guys,

First post here, I find the forum very helpful normally and haven't needed to post yet. Thanks in advance for any help.

I can't figure out how to populate my comboBox1 with the first column of my excel table table1.
It seems like I should be able to set my userform1.comboBox1.list equal to the first column in the table1 but I can't seem to figure out the syntax.
The idea is that the comboBox list could be dynamic and grow itself when rows are added to the table.

Any thoughts?

Thanks.

[Tinbendr]

Please Login or Register  to view this content.