Help Required with inputing data to excel worksheet

[colin.burt]

Hey

I am using excel 2003 and am a complete novice, I need to know how I input data using a vba form that I have, where the data will be going into different cells, placed in different rows and columns.

i.e txtOne will go into cell A2, txtTwo will be D5 and txtThree will insert into F3. etc...


Thanks in advance.

[Bob Phillips]

Have an OK button

[vba]

Private Sub cmdOK_Click()

With Me
Worksheets("Sheet1").Range("A2").Value = .txtOne.Text
Worksheets("Sheet1").Range("D5").Value = .txtTwo.Text
Worksheets("Sheet1").Range("F3").Value = .txtThree.Text
End With
End Sub
[/vba]

[YellowLabPro]

Colin,
Are you new to one or the other or both Excel and VBA?
Your question is very broad and cannot really be anwered explicitly. If you want to upload a sheet w/ an example of what you want, we can have a look at how your task can be accomplished.