How to loop through cells and populate combo boxes using VBA and Excel?

I have a worksheet called "Sheet" and each column has a list of variables (column B is Name)

I have a user-form that has ComboBox1.

I want to loop through all column B such that If cell(i,2)<>"" then add that item to the ComboBox1 else exit sub.

This will basically add any non-blank item to the combo box list and will exit the sub when it comes to a blank cell.

I would like to do this under the Initialize() sub so that when the form loads, it will load the most recent list.

Let me know what you all think.

Thanks!

Originally Posted by judgeh59

does this get you going in the right direction?

Please Login or Register  to view this content.

the Me.ComboBox1 is the name of my combobox, yours may be different....

Perfect, u da man. I have added a positive rep! Thanks