Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP/Validation box macro
Hi all......
Is it possible to create some sort of macro that will detect if a 1 is entered in A1 and thereby cause A2 to have a VLOOKUP formula set in it, and if a 2 is entered in A1 to have a Dropdown Validation box appear in A2 instead of the VLOOKUP formula, and back and forth......and if nothing, or anything else is entered in A1, then A2 will remain blank.......... TIA Vaya con Dios, Chuck, CABGx3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Vlookup with validation | Excel Worksheet Functions | |||
Data Validation, VLookup or If ??????? | Excel Discussion (Misc queries) | |||
Data Validation-VLOOKUP | Excel Discussion (Misc queries) | |||
data validation using vlookup | Excel Worksheet Functions | |||
vlookup with validation table | Excel Discussion (Misc queries) |