Alex,

Try

Range("A1").Value = Worksheets("Sheet1").TextBox1.Text

Change the A1 to the appropriate reference.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Alex Martinez" wrote in message
...

Hi,

I want to use a command button to copy a text box and put it in
a define area, but I don't know how to code that. I tired to
use a macro, but I am not getting the text box. Any tips will
be appreicated.