UserForm TextBox to Specific Cell

[Rana Gray]

Hey everyone,

I know there are a million threads on this topic and I have tried everything and I keep getting a runtime 9 error and I can't figure out what I am doing wrong.

My userform has 4 txt boxes and I want to be able to save the values so I created a sheet [Sheet25] "UserForm" to store the data - here is the code I have:

Please help

 

[Rana Gray]

I found a work around!

For anyone else having the same issue though:

Private Sub CommandButton1_Click()
Sheet25.Range("D5").Value = TextBox1.Value
Sheet25.Range("D6").Value = TextBox2.Value
Sheet25.Range("D8").Value = TextBox3.Value
Sheet25.Range("D9").Value = TextBox4.Value
    Unload Me
End Sub