| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Msg Box - User Entry Validation
Hello,
I am writing some vb code which will save a workbook WB.SaveAs ("MyExcelWorkbook.xls") - Now if I have already run this Macro MS Excel prompts the user saying "MyExcelWorkbook.xls" already exists do you want to override. Yes / No / Cancel If the user clicks 'Yes' everything is fine. However if the user clicks No or Cancel the code crashes. How do I build in this validation. Any help would be much appreciated. AC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ç(User Entry)è can any one explain this | Excel Discussion (Misc queries) | |||
| Validation list that also allows user entry? | Excel Worksheet Functions | |||
| Auto email - With every new entry on my user form | Excel Discussion (Misc queries) | |||
| Date Tagging User Entry | Excel Programming | |||
| Prevent non "validation" user entry | Excel Programming | |||
Threaded Mode
