Hi Nick
See the code on this page
http://www.rondebruin.nl/copy1.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"nickjames21" <u40881@uwe wrote in message news:7e9efcf1e2859@uwe...
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