+ Reply to Thread
Results 1 to 6 of 6

MsgBox does not appear after the code executes.

  1. #1
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Smile MsgBox does not appear after the code executes.

    Hi
    I have a code, which works, but I want msgbox appear after the code executes. But it does not. Why?

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by contaminated; 01-05-2010 at 07:51 AM.
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, ?Born in USSR?
    Vusal M Dadashev

    Baku, Azerbaijan

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,444

    Re: MsgBox does not appear after the code executes.

    Just a wild stab in the dark, but do you need Screenupdating turned on to display a messgae box?

    Dave

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: MsgBox does not appear after the code executes.

    Listboxes are zero based.
    You are trying to access item 40, which does not exists.

    Please Login or Register  to view this content.
    Always a good idea when code with Error trapping is not working is to remove the error trapping in order to see the actual error. Put it back when reason is understood and resolved.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Valued Forum Contributor Richard Schollar's Avatar
    Join Date
    05-23-2006
    Location
    Hampshire UK
    MS-Off Ver
    Excel 2002
    Posts
    1,264

    Re: MsgBox does not appear after the code executes.

    Is your code ever getting to that line or is it erroring out thus skipping to your Unload Me line? Just plonk a message box after oops indicating if an error was made:

    Please Login or Register  to view this content.
    Richard Schollar
    Microsoft MVP - Excel

  5. #5
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: MsgBox does not appear after the code executes.

    Hi sweep
    Thx for responce
    Actually I dont need screenupdating at all.

  6. #6
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: MsgBox does not appear after the code executes.

    Thank u for all your responces
    RichardSchollar
    Workde like a charm!!!!!!!!!!!!!

+ 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