Add data from column "A" that is located on a sheet called "Catalogus

After so many tries I still can't figure out how to do the following.

The situation is as follows:

I have a Catalogue that contains hardware that is stored in a Sheet called "Catalogus_Hardware", all the hardware is located in column A. I want that hardware to show up in my ComboBox called ComboBox1.

Currently I have it "configured" like this:

Private Sub UserForm_Activate()
With Me.ComboBox1
        .Clear
        .AddItem ""
        .AddItem "Device1
        .AddItem "Device2"
        .AddItem "Device3"
        .AddItem "Device4"
End With
Call Refresh_Data
End Sub

But I don't want it that way because adding an item one by one just takes too much time.

What I want is when I update my catalogue it automatically updates the hardware in my ComboBox as well.

Thanks in advance

I watched several tutorials, guides etc,... But I keep doing something wrong and I have no idea what.

CodePudding user response：

give a name to your list with hardware:

(you can change the range of the list on sheet change to make sure latest added hardware is added)

Assign that name to the input range of your combo box:

CodePudding user response：

I feel so stupid xD. I Just changed the RowSource in the properties of my ComboBox and tadaaaa. . But thank you for your help Frederik :D