You can populate a dropdown with a list on another sheet by referencing the cells, but the resulting dropdown won’t be dynamic, even when the list is in a table object.

Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.

I have a combobox that I want to populate with a list of vendors stored in another Access Database. This database contains roughly 1,300 different vendor records. All I'm interested is the names.I ...