how to submit a data in excel vba in different workbook or sheet

hi all,
i m looking for help to submitting a data from 1 data form to other workbook by clicking on submit button..

Private Sub cmdsubmit_Click()
Call TNX
Dim emptyrow As Long
'Determine emptyRow
emptyrow = WorksheetFunction.CountA(Range("A:A")) + 1
'Export Data to worksheet
Cells(emptyrow, 1).Value = cbx1.Value
cbx1 = Empty
Cells(emptyrow, 2).Value = cbx2.Value
cbx2 = Empty
End Sub

i m using this code but with this code when i click submit button i m getting a data in form type(which i want aswell) on the same sheet where i create the form,,i like to get this data on different workbook,,,i dont want the data on same sheet

will b very thankful for help

sorry i think its bit confussing question.i try to make it simple
i like to submit data from one excel vba active file to another excel file.

try this

Please Login or Register  to view this content.