Submit Data form in one tab to another tab in same excel?

  • Thread starter Thread starter ksee
  • Start date Start date
K

ksee

Looking for a way to have a form setup on one tab and have a submit button
that would then push that data to the next tab in row format. Can this be
done?
 
Looking for a way to have a form setup on one tab and have a submit button
that would then push that data to the next tab in row format. Can this be
done?
Click to expand...

Ksee,

Yes, this can be done. Here is a simple example which inserts the
value from the text box on the user form into cell A1 on the first
worksheet. The code executes when you click the command button on the
user form.

Best,

Matthew Herbert


Private Sub CommandButton1_Click()

With UserForm1
Worksheets(1).Range("a1").Value = .TextBox1.Value
End With

Unload UserForm1

End Sub
 
Back
Top