| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get a MsgBox to pop up if I have VBA write a wrong link
I have a macro that writes a formula in the worksheet that links to
another worksheet. So the VBA code looks something like this "='C: \PROJECTS\[OtherWorkbook]Sheet1'!A1". The macro is working, but if somehow I define the address wrong, Excel then pops up the Explorer form asking me to find the "correct" file. Is there an error trapping code that I can use in my macro to stop the macro BEFORE the Explorer form comes up, so that I can have my own MsgBox pop up and then end the macro run? Many thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Modify to write results into B2 down instead of msgbox | Excel Programming | |||
| MsgBox FOR SELECTING WRONG FORMAT FILE | Excel Programming | |||
| My program read the wrong msgbox | Excel Programming | |||
| My 3rd Msgbox is popping up in wrong position | Excel Programming | |||
| Wrong text in msgbox | Excel Programming | |||
Threaded Mode
