+ Reply to Thread
Results 1 to 3 of 3

A checkbox in a MsgBox?

  1. #1
    Registered User
    Join Date
    02-20-2012
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2010
    Posts
    25

    A checkbox in a MsgBox?

    Hello all,

    I have a working Excel VBA "Checker" (validation) script that gets launched on a worksheet by a button. After the "Run the Checker" button is clicked, a MsgBox dialog is presented, asking the user if they want to Proceed or Cancel. Similar to this:

    Please Login or Register  to view this content.
    What I would like to do is add a checkbox to that MsgBox, in order to get the user to flip a switch, so to speak. Based on whether the checkbox is checked, I would set a flag in my code to do some different tasks.

    And as long as I'm considering this approach, I could foresee in the future perhaps adding a second and third checkbox.

    I'm all about keeping this simple. I'm not looking to build a front-end! I've got my hands full building out the back-end logic!

    Is this possible with the MsgBox function? Or do I need a completely different mechanism?

    In a nutshell, I presently have two options I'd like for the user to choose from, a "quick check" or a "thorough check".

    Please point me in the right direction. Thanks in advance!

    Flatlander by the Lake

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: A checkbox in a MsgBox?

    You need to create a userform that looks like a message box as I am pretty sure that message boxes cannot be altered that way.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  3. #3
    Registered User
    Join Date
    02-20-2012
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: A checkbox in a MsgBox?

    That's what I thought. Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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