Home |
Search |
Today's Posts |
#1
|
|||
|
|||
combo box for new excel user
how do i add a drop down list from a combo box?
|
#2
|
|||
|
|||
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 |
#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 "Lilydog7" wrote: how do i add a drop down list from a combo box? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel User Conference - Early Registration Period Coming to an End | Excel Discussion (Misc queries) | |||
2005 Excel User Conference - Sept 16/17 | Excel Discussion (Misc queries) | |||
How do I save a worsheet from Excel 2002, for a user with Excel 2. | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
how would i change default user name all excel files | Excel Discussion (Misc queries) |