Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help with creating a combo box with a drop down arrow
I'm working in Excel with a fom that I would like to create combo box where I
can make selections of different items available. Please help. |
#2
|
|||
|
|||
Take a look at Data|Validation.
Debra Dalgleish has some instructions with nice pictures at: http://www.contextures.com/xlDataVal01.html Elizabeth wrote: I'm working in Excel with a fom that I would like to create combo box where I can make selections of different items available. Please help. -- Dave Peterson |
#3
|
|||
|
|||
Thanks for responding but that didn't return the results that I'm looking
for. I would like to create several combo boxes on the form where multiple selections can be made from another (data) workbook. My first question does the worksheet where the data resides need be in the same workbook as my form or can I somehow link it. If I link it does the data workbook have to open every time I access the form. Is there some code that I tell the form to at look in a particular workbook for the list of items? "Dave Peterson" wrote: Take a look at Data|Validation. Debra Dalgleish has some instructions with nice pictures at: http://www.contextures.com/xlDataVal01.html Elizabeth wrote: I'm working in Excel with a fom that I would like to create combo box where I can make selections of different items available. Please help. -- Dave Peterson |
#4
|
|||
|
|||
I'm not sure how you can use multiple selections in a combobox.
I put a combobox from the control toolbox toolbar on a worksheet and added a name to that workbook that refered to the other workbook's range. When I closed the listfillrange workbook, it broke the combobox. Maybe you could use a bunch of formulas (on a hidden sheet) that retrieve values from the closed workbook and use that for the listfillrange. ='C:\My Documents\excel\[book2.xls]Sheet1'!A1 and drag down as far as you need. Elizabeth wrote: Thanks for responding but that didn't return the results that I'm looking for. I would like to create several combo boxes on the form where multiple selections can be made from another (data) workbook. My first question does the worksheet where the data resides need be in the same workbook as my form or can I somehow link it. If I link it does the data workbook have to open every time I access the form. Is there some code that I tell the form to at look in a particular workbook for the list of items? "Dave Peterson" wrote: Take a look at Data|Validation. Debra Dalgleish has some instructions with nice pictures at: http://www.contextures.com/xlDataVal01.html Elizabeth wrote: I'm working in Excel with a fom that I would like to create combo box where I can make selections of different items available. Please help. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating drop down list for multiple cell ranges | Excel Discussion (Misc queries) | |||
creating drop down lists where you can select multiple values | Excel Discussion (Misc queries) | |||
How do I create a combo drop down list in Excel? | Excel Worksheet Functions | |||
Creating Drop down menus in an excel cell | Excel Worksheet Functions | |||
Drop down list or combo box help needed | Excel Discussion (Misc queries) |