Problems Closing User Form

[Guzzlr]

Hello All,
I have a worksheet with two Click Buttons:
One button Clears the Work Sheet
The second buttons Shows the User Form.

What I'm trying to accomplish, is turn off the User Form when I press the Clear Work Sheet Btn. So, pressing the Clear button will turn off the User Form, and complete clearing the worksheet.
The problem is the User Form is showing, and will not allow me to press the Clear Button. I have to "X" out of the User Form, before excel will allow me to press the Clear btn.

Does that make sense?
Thanks for the help
excel 2013

 

[Fluff]

Change ShowModal in the properties window to False

 

[cooper645]

Could always add a button to the form that clears the worksheet and hides the userform

 

[Guzzlr]

Change ShowModal in the properties window to False

Ohh...Very Nice
Thank You

 

[Fluff]

Glad to help & thanks for the feedback