Problem with variables in userform

Hi

In a userform I have two textboxes. What I write in these two textboxes I want to put in two different cells. I have this code here. But there is something wrong. Please help me.

Private Sub CommandButton1_Click()
Dim aarstal As Long
Dim dato As String
aarstal = TextBox1
dato = TextBox2




End Sub


Private Sub CommandButton2_Click()
Dim aarstal As Long
Dim dato As String
  With Sheet1
    .Cells(1, 1) = aarstal
    .Cells(2, 1) = dato
End With
  Application.ScreenUpdating = False
Unload Me
End Sub

Alring

Re: Userform

Thank you so mush badger101. Now I can see what an idiot I have been. Maybe I should ask my boss to have a reading course. I think it will be on is't place to get one of these NOW.

Thank for you help. And sorry to all that I asked above this.

:thanx:
Alring

Re: Problem with variables in userform

Hi Roy

OK. I will try to do that. But my english isn't the best here on this planet. :redface:

Alring