Poplating a cell from a form

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?

PHP Code: 

Private Sub submitOrder_Click()

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

End Sub 


Just change to this:

your textbox has a number on the userform, you can use this to specify wich textbox's value you insert.

Private Sub submitOrder_Click() 

Worksheets("Master").Cells(9, 1).Value = TextBox1.value ' asuming it's the only texybox on the userform

End Sub

Thanks Steffen, this has worked in part. I do have other variables to populate the row as per the code below. However when it update cell(9, 1) with customer input, it then reverts to Worksheet_Change(ByVal Target As Range) event and does not populate the spreadsheet with the remaining variables. Do you know whyit is going to the worksheet change event?


Private Sub submitOrder_Click()

Worksheets("Master").Cells(9, 1).Value = customerInput.Value
Worksheets("Master").Cells(9, 2).Value = TextBox1.Value
Worksheets("Master").Cells(9, 3).Value = TextBox2.Value
Worksheets("Master").Cells(9, 4).Value = TextBox3.Value
Worksheets("Master").Cells(9, 5).Value = TextBox4.Value
Worksheets("Master").Cells(9, 6).Value = TextBox5.Value
Worksheets("Master").Cells(9, 7).Value = TextBox6.Value


End Sub




Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

Hi,

Remember to put code tags around your code.

Can you post a dumme workbook with your code?

Steffen Thomsen

Hi,

It works fine with me.

Maby just add this before end sub

Unload me

Steffen Thomsen