Cell

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

Hi,

I am trying to program a macro that will take what has
been entered in a textbox on a user form and place it in
cell A3.

Can anybody help please
Thanks
 
Try something like:

Sub Test()
Dim cell As Range
Set cell = Sheets("Sheet1").Range("A1")
cell = UserForm1.TextBox1.Value
End Sub

HTH
Jason
Atlanta, GA
 
Worksheets("Sheet1").Range("A3").Value = Textbox1.Text

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Should state that this is if the code is in the userform, if not precede the
Textbox with userform name and dot

Worksheets("Sheet1").Range("A3").Value = Userform1.Textbox1.Text

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
If i have a spreadsheet which the path is :-
H:\temp\test1.xls
I want my userform information which is on a different
spreadsheet to fill into the spreadsheet above, how would
i put that.

thanks
 
Add the workbook details to the code posted.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Workbook("H:\test1.xls").Worksheets("Sheet1").Range
("A1").Value = txtdate.Text

This is what i've got but it's not working.
aaaahhh. as you can tell i'm still learning !!!!
 
It's Workbooks not Workbook, part of a collection .

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top