Textbox value copy from one worksheet to another worksheet

L

LRay67

I am trying to copy the value from one textbox on one worksheet to another
worksheet. Any suggestions. Thanks

Linda
 
J

JLGWhiz

Worksheets(2).Range("A1") = Worksheets(1).TextBox1.Text

Or

Worksheets(2).Range("A1") = Worksheets(1).TextBox1.Value
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Textbox from 1st worksheet to textbox to other multiple sheets 2
Embed the same Excel multiple times 0
Excel 2013 Merge Data 2
copy text from textbox to another application 3
Macro to copy rows into worksheets 4
Textbox input goes to 2 sheets in same wbk 0
Snake pre-defined range from multiple worksheets. 0
Sheet name=Cell value 2

Top