Easy Newbie Question

MazPower · Apr 9th, 2002, 09:23 AM

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 · Apr 9th, 2002, 09:35 AM

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

MazPower · Apr 9th, 2002, 10:09 AM

still dont work!
Maz

MazPower · Apr 9th, 2002, 11:19 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 09:23 AM	#1
MazPower New Member Join Date: Apr 2002 Posts: 5	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

Apr 9th, 2002, 09:35 AM	#2
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	Private Sub CommandButton1_Click() Worksheets("Rapport").Range("d3") = Worksheets("Diaquart").TextBox1.Text End Sub

Apr 9th, 2002, 10:09 AM	#3
MazPower New Member Join Date: Apr 2002 Posts: 5	still dont work! Maz

Apr 9th, 2002, 11:19 AM	#4
MazPower New Member Join Date: Apr 2002 Posts: 5	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