User Form won't clear Data in worksheet

[jdwoods]

I have a user form that inputs data to workbook, when I run the user form in VBA developer everything works properly. The problem is I open the excel file and run the program the data does not clear in the workbook therefore making my calculations wrong. What is causing the workbook not to clear in when running the program outside the developer page? I can provide more details if needed.

 

[jolivanes]

What is the code that should clear the worksheet?

 

[jdwoods]

Sub sbClearEntireSheetOnlyData()
Sheets("Canola Data Table").Range("A10:D10").ClearContents
End Sub

When you click on the clear button on the user form nothing happens. It does clear the textboxes or the data table. I need both to clear so user can re use the form over and over. Data in the table also wont' clear when closed, the user form resets. Below is what I am using to close the user form.
Private Sub CmdClose_click()
Unload Me
End Sub

 

[RoryA]

How have you linked that code to the button?

 

[jkpieterse]

What happens if you change this to:

Sub sbClearEntireSheetOnlyData()
    ThisWorkbook.Sheets("Canola Data Table").Range("A10:D10").ClearContents
End Sub

 

[jdwoods]

How have you linked that code to the button?

I have a CMDbutton on the user form.

 

[jdwoods]

What happens if you change this to:

Sub sbClearEntireSheetOnlyData()
    ThisWorkbook.Sheets("Canola Data Table").Range("A10:D10").ClearContents
End Sub

I tried this but still nothing, do i have to add a module to the user form referencing this code to get the CMD Button to work.

 

[RoryA]

What's the code behind the commandbutton?

 

[jdwoods]

What's the code behind the commandbutton?

I think I found one the issue looks like I have not add it yet or have delete as I could not get it to work as it just has Private SUB Clear_Click() END SUB, SO can just add the code that jkpieterse provided.

 

[jdwoods]

Thanks Guys for your Help