+ Reply to Thread
Results 1 to 2 of 2

MsgBox pops up twice in this sub?

  1. #1
    Forum Contributor Rick_Stanich's Avatar
    Join Date
    11-21-2005
    Location
    Ladson SC
    MS-Off Ver
    Office365
    Posts
    1,167

    MsgBox pops up twice in this sub?

    I do not understand why the MsgBox pops up twice if I enter a character other than what is specified (P, T, F or leave blank)?
    The text in the MsgBox only exists in this sub and no where else.
    Please Login or Register  to view this content.
    Any hints, tips, examples or aspirin is appreciated.
    Last edited by Rick_Stanich; 09-17-2009 at 04:44 PM.
    Regards

    Rick
    Win10, Office 365

  2. #2
    Forum Contributor Rick_Stanich's Avatar
    Join Date
    11-21-2005
    Location
    Ladson SC
    MS-Off Ver
    Office365
    Posts
    1,167

    Re: MsgBox pops up twice in this sub?

    I think I know why. The macro performs its code processes through the Call's and has to reroute back through again.
    I ended up adding
    Please Login or Register  to view this content.
    in the Case Else event.

    This also meant I can remove this code from th esame event as I think it is not needed.
    Please Login or Register  to view this content.
    Last edited by Rick_Stanich; 09-17-2009 at 04:43 PM.

+ 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