Hi,

I'm trying to create a userform with a combobox that creates a drop-down list of dynamic products from column F5. I kind of figured that part out and came up with this...

Private Sub UserForm_Initialize()

 ComboBox1.RowSource = ""
 ComboBox1.List = ActiveSheet.Range("F5", ActiveSheet.Range("F" & Rows.Count).End(xlUp)).Value

End Sub
It works ok except it includes cells in column F that are blank. Is it possible to add something to the above to leave out any blank cells?

The next part is where I'm totally lost.

I'll have a text box next to the drop-down list to enter a quantity number. So for example if I select product A from the combobox list, I can then enter a quantity and submit the form, the quantity needs to go in column G in the corresponding cell for the product. So if the selected Product A is in cell F32, then the quantity goes in cell G32.

Is something like this possible?

Any guidance would be greatly appreciated.

Thank you!