Combo Box...

L

ladoski

How do I add rows to a combo box? I need to add a simple drop down box that
contains simple data, but I need the formatting (border, scroll...) to remain
in view. Is a combo box what I'm looking for?
 
G

Gord Dibben

View>Toolbars>Control Toolbox.

Click on the "design mode" button.

Click on the "combobox" button.

Draw a combox box on the sheet.

Right-click on the combobox and "Properties"

Edit the ListFillRange to the range of items you have listed on a sheet, say
A1:A23

Pick a "linked cell" to link your selection to.

Set the ListRows to the number items you want to see when you click on the
arrow.

Hit the "x" to close.

Click on the "exit design mode button" and you're good to go.

These are the very basics. Adjust and add more functions as you wish.

For more on ComboBoxes and Data Validation see Debra Dalgleish's site.

http://www.contextures.on.ca/xlDataVal11.html


Gord
 
Top