+ Reply to Thread
Results 1 to 2 of 2

escape causes error

  1. #1
    Registered User
    Join Date
    10-03-2012
    Location
    San Antonio TX
    MS-Off Ver
    Excel 2010
    Posts
    22

    escape causes error

    This code works great...

    Please Login or Register  to view this content.
    ..unless I, during the selection of the picture, change my mind and hit the escape key. It closes the folder where the pictures are stored and takes me back to Excel where I am notified of a "file not found" error that stops everything. How do I code in such a way so as to prevent the error if someone changes their mind about choosing a picture during the process?

    DJams

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: escape causes error

    Hi,

    Does this link help?
    http://www.ehow.com/how_8747529_exit-sub-vba.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1