D Debra Dalgleish Oct 7, 2005 #2 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.
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.
G Guest Oct 8, 2005 #3 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
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
