In my excel spreadsheet, I have a ListBox which I would like to populate based on values inputted in a UserForm I have made, but I can't figure out how to do this.

To clarify, I have a sub that will add items to this Excel ListBox (Private Sub AddItemsToListBox). When the user selects a value from a UserForm I have created, I would like to call AddItemsToListBox so that the value that was selected will be added to the ListBox.

I tried creating a sub in a regular module, and using Application.Run in my UserForm code, but obviously it won't recognize the ListBox as an object.

Any help would be greatly appreciated!

Thanks.