Poplating a cell from a form

[ewan1979]

Hi All,

I am trying to poplate a cell on the spreadsheet from a form.

The workseet is called Master and the form is called orderForm. I am trying to populate the cell(9,1) with the text box customerInput on the form with the code below, but I get the error 'Subscript out of range'. Could anyone assist?

Private Sub submitOrder_Click()

Worksheets(Master).Cells(9, 1).Value = customerInput

End Sub