cancel button

  1. B

    Code mysteriously failing to initiate after selecting the "Cancel" option in a message box.

    I have one subroutine that calls many other subroutines based on a number of buttons/conditions I've set up in my Excel worksheet. Below is a truncated example of this. Public a as Integer Public ans as Integer Public Sub StartingMacro() If Application.Caller = "button1" Then Call Macro1...
    • bellg
    • Thread
    • answer choice cancel button reset button subroutine call variable
    • Replies: 10
    • Forum: Excel Questions
  2. D

    Trouble using isdate and checking if cancel pressed.

    Hello all, I am a definite newby to all this, so please be gentle with me! I haven't done programming really since back on the Commodore 64. Some of this seems intuitive, some just does my head in. I have the following code: Sub GetDate() 'set colours for pass/fail validations ok = 42 notok...
  3. R

    Cancel does not work in a sub - Can sb help please?

    Hi all, I have a small user form which shoes a countdown in seconds, then it closes and goes back to the main Routine and executes some staff (this repeates several times). Now my propblem, I have a cancel button on the form but I can not press it, resp. nothing happens, any idea why. I want to...
  4. J

    How do I stop a Input Box Loop for a Password when user clicks cancel?

    Hi guys, So my workbook is protected. I need a macro which prompts a InputBox saying "Please Enter Password." If the password is incorrect, it says, "Incorrect password. Please try again." and loops to the first input box. However... if they hit cancel, I want it to shut off the document...
  5. T

    remove or disable the cancel button in an input pop up window

    i want to remove the cancel button to force a user to enter there name before they can access the workbook. if i can make the cancel button close the workbook with a error message that would be good. The input box that asked for the week start date i would like to not be shown if there is...
    • tomtat
    • Thread
    • cancel button popup input window vba & excel
    • Replies: 6
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top