submit / update macro

ElBenno

Board Regular
Joined
Jun 3, 2005
Messages
97
Hi,
I am trying to create 2 work sheets. One is just a simple table (register). The other I want to be able to use as a sort of Form where i can enter data into the cells and then click a submit / update button that will then populate the register. Can anyone help with this macro or VBA.

Kindest Regards,

ben
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

ElBenno

Board Regular
Joined
Jun 3, 2005
Messages
97
My register is a normal table:

Date Identification method Details Names Involved


Then the other sheet i want to be like a form that runs down the page:

Date:_______________

Identification Method: <<A boxed cell / field here for text>>

Does that help??
 

agihcam

Well-known Member
Joined
Jan 16, 2006
Messages
1,624
you can start with this code;
Code:
Private Sub CommandButton1_Click()
Sheets("register").Range("a" & Rows.Count).End(xlUp).Offset(1) = Sheets("form").Range("a1")
Sheets("register").Range("a" & Rows.Count).End(xlUp).Offset(, 1) = Sheets("form").Range("a3")
Sheets("register").Range("a" & Rows.Count).End(xlUp).Offset(, 2) = Sheets("form").Range("a5")
End Sub
 

Forum statistics

Threads
1,141,759
Messages
5,708,361
Members
421,566
Latest member
7Nabisco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top