Easy Newbie Question

[MazPower]

first the names
excel workbook = project(4)
sheet with dialog box = DiaQuart
in sheet diaquart there's my textbox= Date
answer should go to same workbook,
sheet= rapport, cell=D3
---------------------------------
my question
please answer step by step because i am ery good in excel but looks like i cant understand nothing from vba even the dumbest
line of code!!

ok i've made a dialog box, i have a lot of textbox that the user has to fill in with his info. i want these info to be copied to a specific cell in my worksheet(rapport(D3))
when the user press the ok button.

should be easy to answer isint it?
cant figure it out!!

Thanks
MAZ

 

[Mr Nick]

Private Sub CommandButton1_Click()
Worksheets("Rapport").Range("d3") = Worksheets("Diaquart").TextBox1.Text
End Sub

 

[MazPower]

still dont work!
Maz

 

[MazPower]

anayone can send me an simple example
of how to copy the data from a textbox in a msgbox to a worksheet so i can compare the code
thanks
maz