PDA

View Full Version : Help Required with inputing data to excel worksheet



colin.burt
11-10-2007, 10:47 AM
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
11-10-2007, 10:58 AM
Have an OK button



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

YellowLabPro
11-10-2007, 10:58 AM
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.