+ Reply to Thread
Results 1 to 5 of 5

Loop in canceling of event

  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    458

    Loop in canceling of event

    Hello everyone.

    I have a bug that causes a loop in in my code. Let me walk you through it:

    A user is prompted to select a Port


    Please Login or Register  to view this content.
    Say the user changes her mind and does not want to select any Port, she wants to quit, I have a cancel button

    that is supposed to do this,

    Please Login or Register  to view this content.
    The problem is that the cancellation button is not wokring properly. When you press "Cancel" it loops back to "Please select a product from the list provided" instead of exiting the userform.
    Any suggestions?
    Last edited by AnthonyWB; 01-30-2011 at 07:15 PM.

  2. #2
    Valued Forum Contributor Charles's Avatar
    Join Date
    02-10-2004
    Location
    Biloxi
    MS-Off Ver
    Windows 7, Excel 2003,2007 & Mac2011
    Posts
    845

    Re: Loop in canceling of event

    hi,


    Not sure if this is correct, but did you try Exit Sub after the "Unload Me"
    Charles

    There are other ways to do this, this is but 1 !
    Be Sure you thank those who helped.
    IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Loop in canceling of event

    Please Login or Register  to view this content.



  4. #4
    Valued Forum Contributor Charles's Avatar
    Join Date
    02-10-2004
    Location
    Biloxi
    MS-Off Ver
    Windows 7, Excel 2003,2007 & Mac2011
    Posts
    845

    Re: Loop in canceling of event

    snb,

    I should have seen that, because I just addressed the same issue in another forum.
    May be I should take my "Blinders" off.

  5. #5
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    458

    Re: Loop in canceling of event

    snb,

    Thank you. the issue is resolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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