Hi sorry to bother,

I have a userform which I have created and I would like to transfer the
information that i put in to textbox1 and copy this information onto a
speadsheet called (template) I have set up. I have worked all other things
out at this stage but when i try to use the code i put it actually copies
the code and pastes that onto the spread sheet


Thanks in advance

Greg