Copying text from a text box into a cell on another sheet
 

Hi all

i need to know how to make a macro that when i press a button will copy
the information from 7 text boxes, (my Inout Form) and then places them
into a table lengthways. If yo have any idea on how to do this or
would like me to send you the system i am working on then please e-mail
me at

cheers

from ck


---
Message posted from http://www.ExcelForum.com/

Copying text from a text box into a cell on another sheet
 

Keeping to the NG.

For each of the text boxes set the ControlSource to the address of the
relevant cell you want updated.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"cakonopka " wrote in message
...
Hi all

i need to know how to make a macro that when i press a button will copy
the information from 7 text boxes, (my Inout Form) and then places them
into a table lengthways. If yo have any idea on how to do this or
would like me to send you the system i am working on then please e-mail
me at

cheers

from ck


---
Message posted from http://www.ExcelForum.com/