Userform - Continue and cancel command buttons code

Hi all,

I hope someone can help me please?

I have my userform and currently it goes through my excel document and ticks a check box if the header is there (fantastic!).
I am hoping to add two command buttons to the end to allow the user to continue with the macro or cancel the macro and return to the workbook but I am struggling with the code I need for this - could someone please advise me on this?

Below is the code for the check boxes which I will need to add to for my other two buttons.

Thanks for your help.

Please Login or Register  to view this content.

Hi,

By 'continue with the macro' I assume you mean you want some other macro code to be run..

Add your two command buttons and use the Click Event.

In the button for continuing enter

Please Login or Register  to view this content.

and in the cancel button use

Please Login or Register  to view this content.

and set the Cancel Property of the button to True which will ensure the form is unloaded if the 'X' is clicked or if the {Esc} key is used.

Obviously change the Module1, UserForm1 to reflect your object names.

HTH