| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation using VBA to reference to another book
I have got 2 workbook. book1.xls is for application and book2.xls is a database that looks like this
A B Name1 CompanyA Address Name2 CompanyB Address Name3 Company C Address In book1.xls cell B1, I want to create a drop down list (data validation) making reference to book2.xls column A, i.e. when cellB1 is focus, I will see Name1, Name2, Name3 in the drop down list. How can I achieve this |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i reference an external workbook for data validation? | Excel Discussion (Misc queries) | |||
| Data Validation - reference to another workbook | Excel Worksheet Functions | |||
| Best Excel Reference Book | Excel Discussion (Misc queries) | |||
| VBA Reference Book? | Excel Discussion (Misc queries) | |||
| VBA Reference Book? | Excel Programming | |||
Hybrid Mode
