I have a button in my worksheet that when its pressed it first loads a userform then after userform is filled out it does some more code but I want it so that if I click the red X at the top of the userform it dosnt finish the rest of the code... how could this be done?.... heres the code for the button in my worksheet
Sub New_Tool_study()
UserForm2.Show
Sheets("Tool Data").Visible = True
Sheets("Tool Data").Select
Rows("3:3784").Select
Selection.ClearContents
With Selection.Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With
Range("A3").Select
Sheets("Tool Data").Visible = True
Sheets("Enter").Select
End Sub
Bookmarks