Copy data into/from textbox
 

Hi,

I have two textboxes (drwaing toolbar) in my worksheet using Excel2003.
I need to type in one textbox and have the contents of it copied
automatically into the second textbox. Is it possible using any other
way. The code I am currently using is in a seperate cell that is
supposed to do this job. Here is the code I have

=IF(Name.text <"",Name2.text=Name.text,"")

Obviously, it doesn't work. I am new at excel programming so currently
avoiding doing macros etc. Please help