+ Reply to Thread
Results 1 to 3 of 3

MsgBox pops up twice - Should be once!

  1. #1
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    MsgBox pops up twice - Should be once!

    Hello

    The red line in the following code pops up twice because of the line below it....however I do want the checkbox value to be False if and after the message appears, any ideas to only have the message appear once?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,274

    Re: MsgBox pops up twice - Should be once!

    You need a control variable declared at the top of the userform:
    Please Login or Register  to view this content.
    then the code becomes:
    Please Login or Register  to view this content.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Re: MsgBox pops up twice - Should be once!

    Thought it might be something like that!

    I tried Application.ScreenUpdating but obviously was the wrong idea!

    Thanks, I'll remember this one!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Problem with VBA Editor uses lower case on some lines (ex. msgbox instead of MsgBox)
    By stubbsj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-14-2013, 06:59 PM
  2. Allow deny cancell - msgbox pops up while sending mail through VBscript
    By yogananda.muthaiah in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2012, 01:37 PM
  3. MsgBox pops up twice in this sub?
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-17-2009, 04:40 PM
  4. [SOLVED] MsgBox pops up twice. Any idea why?
    By Noah in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-13-2005, 06:10 PM
  5. [SOLVED] msgBox pops up twice ??
    By Tempy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2005, 09:05 AM

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