Activate Cancel Button on a Modeless Userform

[mtt23]

Good Afternoon,

This may be a stupid question that I already know the answer to, but;
Is there any way to make a Cancel button on a userform exit the macro and hide the userform?

I know various code to do this when the userform is not modeless:

Please Login or Register  to view this content.

But is there a cheeky way that I don't know about to make the cancel button operate when the form is loaded as modeless??

[Patnaik]

Hello Mr mtt23

I can't understand your question but what ever it may be here is a code for you

Please Login or Register  to view this content.

With Regards

Patnaik

[mtt23]

I have set a userform to modeless because I am using it as a status bar while the macro runs and I want it to stay up on the screen, but in modeless, the usual code that I would use for the cancel button will not work.

I am asking, is there a way to make canel work when form is modeless. Or not?

[mtt23]

No wizards around that can clarify this for me?

[Andy Pope]

Something like this perhaps.

Userform simply displays the time until user cancels

code module

Please Login or Register  to view this content.

Userform with command button and label

Please Login or Register  to view this content.

Note: Avoid using END in your code as it free all memory used by VBA, including private and publically scoped variables.

[JosephP]

you would normally do this using a public variable that is set by the cancel button and checked periodically by your macro but unless your macro yields control occasionally (using doevents for instance) it will be hard to get the form to do anything.

[mtt23]

Thanks guys!

Joseph, I think I will have to do something along the lines of that, as I already have occasional code throughout the main macro which updates my progress bar within the same userform...

[tmbo13]

Thanks Andy, I found this extremely useful for a macro I am building. Cheers