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!