Userform data

[MUKESHY12390]

Hi ,frnds ,
Is anybody know Following thing.
How i can save data form Userform to another workbook..( at same time ,that workbook should not be active. ).
Let me give example:-
Userform of Workbook("TimeTracker") and I need data of userform in Another workbook("Mainworkbook")
Thanks in Advance..!

 

[Andrew Poulsom]

Just qualify the range you want to update with its Workbook and Worksheet. Example:

Workbooks("Mainworkbook.xls").Worksheets("Sheet1").Range("A1").Value = TextBox1.Value

 

[MUKESHY12390]

Just qualify the range you want to update with its Workbook and Worksheet. Example:

Workbooks("Mainworkbook.xls").Worksheets("Sheet1").Range("A1").Value = TextBox1.ValueE

Thanks.. Andrew...! your code works perfect when Workbooks("Mainworkbook.xls") is active

But
When Workbooks("Mainworkbook.xls") is not Active it give Run-TimeError 9 (Subscript out of Range)

my problem is that when User Put data in Userform ,Same time data should go in Another Non-Active Workbooks("Mainworkbook.xls")

pls help ...!!!!!

 

[mikerickson]

Andrew's code works for me when Mainworkbook.xls is open, but not the active workbook. It gives me that same error when Mainworkbook.xls is closed.