Macro to Copy Cell Text and Copy to a Text Box

Hi,

Am reasonably new to the world of VBA and was wondering if I could

a) Create a new text box in the Macro
b) Copy Text from a Cell
c) Paste into the Text Box

Many thanks for any infomation anyone can shed.

That Works incredibly well thank-you so much!
There is one more bit which you maybe able to help with
if I then wanted another Macro to change the name with the contents of Cell B Would that be possible?

Really have helped so much already,

Thank-you

Looked at the code properly this morning when I woke up and the answer to my other question was already in there.

Many Thanks