combo box for new excel user
 

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

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

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.

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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

"Lilydog7" wrote:

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