Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Submit Data form in one tab to another tab in same excel?
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a 'Submit' button with in an excel form that will email f | Excel Programming | |||
Excel VB: Problem Clicking Submit In Online Form | Excel Programming | |||
saveto or Submit Form functionality in Excel | Excel Worksheet Functions | |||
Excel VBA to click 'submit' on form | Excel Programming | |||
I wanta infopath form to submit data to an excel databse file | Excel Discussion (Misc queries) |