| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i create a drop-down list using workbooks?
i need to create a drop-down list using the name of the workbook existing in
a folder, so i can select one of them and run a macro...i saw this action once but i can't do it, i don't know where are these options...and when you add a new file or workbook to the folder ir appears in the drop-down list in excel...i think i had to use macros but i don't know how to perform this operation.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i create a drop-down list using workbooks?
two steps:
1. create a data validation list and a validation pull-down in, say, A1. 2. create a change event macro to monitor cell A1, and if it changes, use the value to determine which macro to call -- Gary''s Student gsnu200710 "Mako" wrote: i need to create a drop-down list using the name of the workbook existing in a folder, so i can select one of them and run a macro...i saw this action once but i can't do it, i don't know where are these options...and when you add a new file or workbook to the folder ir appears in the drop-down list in excel...i think i had to use macros but i don't know how to perform this operation.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a drop down list | Excel Worksheet Functions | |||
| Can I create a drop-down list that will reference other drop-down | Excel Worksheet Functions | |||
| How To Create A Drop Down List? | New Users to Excel | |||
| How do I create a simple drop down box/List | Excel Discussion (Misc queries) | |||
| How do you create a drop down list? | Excel Discussion (Misc queries) | |||
Hybrid Mode
