ComboBox dropdown for a large list

Hi all,

I know enough about Excel & VBA to be dangerous so I'm looking for a bit of help. I have a workbook that includes sheets populated with a data list (tournaments & dates and hotels with complete address info) I have created a Userform that will be used to generate invoices. My plan is to use combobox dropdowns so that I can select from the events list and the hotel list to populate an invoice sheet that is on a separate tab.
How can I pull the data from that sheet to the dropdown list (I don't want to hard code it as the list will be added to over time). Do I just name the range of hotels and have that dropdown use that name to populate the list or is there another way to do this?
Thanks for the help.

Yes, that would be an efficient way to do this. Name the range, and simply use the named range to populate the combo box. However, so that you do not have to keep renaming the range when you add new data, use a dynamic range:

http://www.contextures.com/xlNames01.html

HTH

Jason

Excellent! Thanks for the link.