Flintstone wrote:
Another newbie question:

I can't figure out how to copy text from a particular cell on Sheet1
and paste it into my text box, everything I've tried hasn't worked.

Hi Matt,

There's not enough info for me to be specific, however, if I had a Text
Box on Sheet2 (Excel has given it the name "Text Box 1") and I wanted
it to show the contents of Sheet1 A1 then I would use the following...

Sheet2.Shapes("Text Box 1").TextFrame.Characters.Text = Sheet1.Cells(1,
1).Value

Does this help?

Ken Johnson