Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code for VLOOKUP - linked to another workbook
Hello,
I'm looking for a way of putting a drop down box into a user form. The drop down box will work as a VLOOKUP function. The list used for the drop down box exists in another workbook. So, in a user form, I need a drop down list which populates itself from another workbook. Once a user clicks on an entry in the list, the drop down list acts as a VLOOKUP function. Does anyone know how to do this? If so, please send me an example code. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP issue with #N/A - linked workbook | Excel Worksheet Functions | |||
pulling color from cell of workbook to another linked workbook | Excel Discussion (Misc queries) | |||
Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
Linked cells, VLookup? don't know which to use | Excel Programming | |||
how to use VB code to define vlookup in two workbook | Excel Programming |