Submit Data form in one tab to another tab in same excel?
On May 5, 4:12*pm, ksee wrote:
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?
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
|