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.

Private Sub UserForm_Initialize()

  c01 = "|" & LCase(Join(Application.Transpose(Application.Transpose(Rows(1).SpecialCells(2))), "|")) & "|"
  For j = 1 To 10
    Me("Checkbox" & j) = InStr(c01, "|" & LCase(Me("Checkbox" & j).Caption) & "|") > 0
  Next
End Sub

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

Private Sub CommandButton1_Click()
    Call Module1.YourMacro
End Sub

and in the cancel button use

Private Sub CommandButton2_Click()
    Unload UserForm1
End Sub

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