I'm trying to write a VBA macro which consists of a UserForm with a dropdown menu. In one tab I have a list of items that I want to dynamically fill the combobox with. Does anyone know how to do this? For example, in a sheet 1 I have the following items in column A: apple, pears, oranges, and grapes. Basically, when the userform pops up I want the combobox to consists of the apples, pears, oranges and grapes. This list in column A is always growing and I want the combobox to be populated with items from column A. If anyone can help I would greatly appreciated. Thank you!


Marci