combo box for new excel user

[Lilydog7]

how do i add a drop down list from a combo box?

 

[Debra Dalgleish]

You can use Data Validation to create a dropdown list in a cell. There
are instructions in Excel's Help, and here:

http://www.contextures.com/xlDataVal01.html

If that's not what you're trying to do, perhaps you could provide a few
more details, and someone may be able to help.

 

[knucklehead]

It is easy once you create your Combo Box in excel. Stay in design mode and
Right Click on the Combo Box a drop down list will appear.

Choose properties from the list.

This will allow you to change the combo box in any way you like from text
size Colour and this is where you can enter in items into your combo box.

Go down the list till you find LISTFILLRANGE You can enter in a range of
cells for example if you want the colum A in the combo box then type A:A.

You can even create a combo box drop down list from a completley seperate
workbook.

By typing Exactly as shown [Book2]Sheet1!$A:$A

NOTE to show the list that you create you must be out of Design Mode.

Hope this helps