| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Popup box to enter VLOOKUP value
Is this possible, if so how?
I have a simple VLOOKUP calc from 1 sheet to another. Sheet1. A1,B1,C1,D1 &E1, with A1 being the VLLOKUP value into Sheet2. Rather than selecting the A1 CELL, and placing the value in there. And then the relevant info being displayed in the other cells, How can upon opening up the excel file, a POPUP window with a text box and an OK button appears, and the value is placed into this and the VLOOKup search is then completed. Any idea's code for this, if possible? Regards Corey.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a popup window on a VLOOKUP lookup failure? | New Users to Excel | |||
| Vlookup if #N/A then enter enter data in cell I4 | Excel Discussion (Misc queries) | |||
| My first macro, uses Vlookup but doesnt update unless hit enter | Excel Worksheet Functions | |||
| If Vlookup returns error enter 0 | Excel Worksheet Functions | |||
| WHY DO I HAVE TO CLICK ON THE CELL & ENTER FOR THE VLOOKUP TOWORK | Excel Discussion (Misc queries) | |||
Threaded Mode
