MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combo box


Posted by Frank O'Kelly on January 11, 2001 7:08 PM

Iwould love to find out how to put data into a drop down list or a combo box in excel 2000. I can put the item on the sheet but I am buggered if I can find a way to put a list into the drop down section.


Posted by Dave Hawley on January 11, 2001 10:13 PM


Hi Frank

If your Combo is from the Forms toolbar then:

Right click on you Combo and select "Format Control" then click the "Control Tab" now put you range that contains your list in the "Input range" box.


If from the Control Toolbox:

Right click on it and select "Properties" then Scroll down to "ListFillRange" and type your range, e.g A1:A100

You may want to consider using Data>Validation with "List" as your allowed entries.

Hope this helps

Dave

  • OzGrid Business Applications

Posted by Paul Keetch on February 26, 2001 11:27 AM

I am also having problems with combo boxes. I can create one, insert list contents, but I would like to have the contents appear as a recurring option as the user passes each line down the worksheet. We are tracking call types (inbound, outbound, personal etc) in a call centre where the user manually completes a weekly worksheet.

I would also like to have these fields be reportable using a "=countif()" formula, which I can write, but can't seem to be able to apply to the selections in the combo boxes.

Any ideas first how to embed the combo into the cell, and then how to enable reporting on this data?

Help is much appreciated.

Paul