View Single Post
 
Old 04-03-2020, 04:50 PM
ChrisOK ChrisOK is offline Windows 10 Office 2019
Advanced Beginner
 
Join Date: Sep 2016
Posts: 54
ChrisOK is on a distinguished road
Question Error Handling

Ok Bob, finally got a chance to test it tonight - and appears I still have something wrong.. This error handling is new.. but likely important to start incorporating..


I put the On Error part at the very top (just below the name of the Sub) as directed... then added the ErrHandle: piece below the 'SAVE RESULTS FILE' section


Getting a compile error: Else without If (screenshot attached)



If the user chooses "Yes" then I'd like it to continue w/ scripts
If the user chooses "No" or "Cancel" (which is giving the 1004 error) l'd like the script to just end w/ a MsgBox "Exiting Sub"
Attached Images
File Type: gif error-handling.GIF (16.5 KB, 11 views)
Reply With Quote