Placeing data from sheet1 to sheet2 via a form button

[nickjames21]

I have created my own custom form that I need placed on sheet2 once the
submit button (form control) is pressed. There are 8 fields that I need to
pass. Any ideas? Using Excel 07.
Thanks
Nick

 

[Ron de Bruin]

Hi Nick

See the code on this page
http://www.rondebruin.nl/copy1.htm

 

[nickjames21 via OfficeKB.com]

Hello Ron,

Thanks for the help. Sorry I was unable to access my account. Don't really
know why but here I am. A couple of things...

Thanks for the code. It is working for the most part. However with the
Variable code, I am trying to place all of the info on one row. From cloumns
A:H. The data on the other sheet is in D3, D5, D7, D9, D11, D13, D15 and D17.
I can get it to place all data in the range of D317 but it places all of
the data only column A.

Do you know of a way to just have it place it across the row instead of in
the column?

Any ideas or thoughts help!

Thanks
Nick

 

[Ron de Bruin]

There is a example on the page to do this