Placeing data from sheet1 to sheet2 via a form button

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nickjames21 - 23 Jan 2008 04:08 GMT

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

Reply to this Message

Ron de Bruin - 23 Jan 2008 09:38 GMT

Hi Nick

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

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

>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

Reply to this Message

nickjames21 - 29 Jan 2008 01:26 GMT

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 D3:D17 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

>Hi Nick
>
[quoted text clipped - 6 lines]
>> Thanks
>> Nick

Reply to this Message

Ron de Bruin - 29 Jan 2008 15:55 GMT

There is a example on the page to do this

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Hello Ron,
>
[quoted text clipped - 25 lines]
>>> Thanks
>>> Nick

Reply to this Message