Control Toolbox: How do I use the "Combo Box?"

[Guest]

Hi,

I need a drop down box in a particular cell, getting it there is easy, putting what I want in the drop down box/list is not! How do I get a "List" in the the combo box to read: 1, and then under that number I want 2, all the way up to 5. I want it to work so that I can see the drop down box and when it is selected I can see the numbers 1 thru 5 following each other in order, below each other. I have tried "Edit" under "Combo Box Object", that doesn't work! If I double click the "Combo Box" in the cell, I go into a "Microsoft Visual Basic" screen, then I'm lost!

 

[Frank Kabel]

Hi
why not use 'Data - Validation - List' for this. See:
http://www.contextures.com/xlDataVal01.html

 

[Dave Peterson]

Show the control Toolbox and click on the Design Mode icon (top left icon).

Then rightclick on your combobox from the control toolbox toolbar and select
Properties.

Click on ListFillRange and type in the address of a range that contains your
values (1 to 5).

You may want to type in an address for LinkedCell, too.

Then click on the design mode icon once more and try it out.

====
I think I'd use the Data|validation that Frank suggested. But that dropdown
arrow isn't always visible. (but it's easier to work with.)