View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
kfogle kfogle is offline
external usenet poster
 
Posts: 5
Default How Do I Load a ComboBox From a Dynamic Range

First, make your Customer List into a in Excel List by selecting the
range which includes the customer names and choose...

Data Menu List Create List

Check the box whether you have Headers or not. Click OK.

Click inside your new list. You should notice a blue border and an
extra cell at the bottom that contains a blue asterisk.

Second, select all the cells that contain customers and include the
blue asterisk in the selection. Name that range.

Third, use that Named Range to populate your combo box. When you add
customers, do so by first selecting the cell containing the blue
asterisk. You will notice that your Named Range will automatically
expand and your new customer will be added to your combo box.