I am trying to put a combo box in a userform on VB in Microsoft Excel. I have the data i want in the combo box on a spreadsheet, however i cannot use ControlSource to have more than one. For example i can use Customers!A15 to get data from that cell, however i cannot use Customers!A15:A40 to get data from all required cells. Anyone know how?? Any help will be very much appreciated.