Reports forms coding

Hi Support,

I have written a large procedure that I would like to execute once I have received some user input information. For this I have created a form, which opens as soon as the excel document is opened. The user enters the data required, clicks the OK command button and the data is returned to the excel document. I then have a command to unload the form. As soon as this is done, I then want to call the procedure I have written. For some reason I cannot seem to call the procedure from the code in the form. Please see below:-

Private Sub cmdOK_Click()

Load StyleImportForm

Dim tb1 As Range
Dim tb2 As Range
Dim tb3 As Range

Set tb1 = Sheets("SeasonCodeTable").Range("F2")
Set tb2 = Sheets("SeasonCodeTable").Range("F3")
Set tb3 = Sheets("SeasonCodeTable").Range("F4")

tb1.Value = TextBox1.Value
tb2.Value = TextBox2.Value
tb3.Value = TextBox3.Value / 100

Unload StyleImportForm

Call ScotchStyleImport

End Sub

Private Sub UserForm_Initialize()


TextBox1.Value = "0.00"
TextBox2.Value = "0.00"
TextBox3.Value = "0"


End Sub


Any ideas why this is not working.

Thanks

Martin