+ Reply to Thread
Results 1 to 5 of 5

MsgBox within userform

  1. #1
    Forum Contributor
    Join Date
    04-02-2013
    Location
    Hollywood, Fl
    MS-Off Ver
    Excel 2010
    Posts
    110

    MsgBox within userform

    Hello all,
    I'm attempting to add a msgbox that will prompt the user to validate all data within a userform prior to submitting. I'm familiar with adding a msgbox to the code to prompt the user to validate data, but the original data is still being submitted once the user closes the msgbox. I would like to provide the user the option to go back and correct any data within the userform prior to submitting the data. Thanks in advance for any and all help. I'll keep researching to see if I find any solutions to this on my own.

    Damian37

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: MsgBox within userform

    What code do you have now?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    04-02-2013
    Location
    Hollywood, Fl
    MS-Off Ver
    Excel 2010
    Posts
    110

    Re: MsgBox within userform

    Please Login or Register  to view this content.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: MsgBox within userform

    Hi,

    Before the "With WS" instruction something like (untested)

    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  5. #5
    Forum Contributor
    Join Date
    04-02-2013
    Location
    Hollywood, Fl
    MS-Off Ver
    Excel 2010
    Posts
    110

    Re: MsgBox within userform

    That did it Richard. Thanks so much that was super helpful!!

+ 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. Return to userform after msgbox?
    By dbjofo in forum Excel General
    Replies: 11
    Last Post: 02-06-2014, 12:58 PM
  2. Return to userform after msgbox??
    By dbjofo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2014, 11:47 AM
  3. [SOLVED] How to unolad userform using msgbox
    By GIS2013 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-29-2013, 05:52 PM
  4. Substituting MsgBox with Userform
    By Volkanismo in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-26-2011, 03:12 AM
  5. Adding MsgBox to Userform
    By buckchow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2007, 12:45 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