Inserting data into a different worksheet

[rickalty]

Hello, I have a VBA form that a user completes to add data. When the
form is closed, I can transfer the data into the current worksheet by
this....


Code:
--------------------

Range("h" & TankLine).Value = txtDate.Text
Range("i" & TankLine).Value = txtTime.Text
Range("g" & TankLine).Value = txtInits.Text

--------------------


but I can't get it to put data into a different worksheet in the same
workbook. I have tried


Code:
--------------------

Sheet1.Range("h" & TankLine).Value = txtDate.Text

--------------------


and


Code:
--------------------

Sheet1!Range("h" & TankLine).Value = txtDate.Text

--------------------


but neither works.

How do I do this, please?

Thanks,
Richard

 

[Chip Pearson]

Try

Worksheets("Sheet2").Range("h"&TankLine).Value = txtDate.Text


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"rickalty"
message
news:[email protected]...

 

[rickalty]

Thank you! That worked perfectly.

Richard