Copy a Textbox to a range on different worksheet

L

LRay67

Can someone please assist me in how I would go about copying a textbox value
to a specific range in same workbook but different sheet?

Thanks in advance

LRay
 
G

Gary Brown

This is the syntax...
Sheets("Sheet1").Range("C4").Value = _
Sheets("Sheet2").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

copy text from textbox to another application 3
Textbox from 1st worksheet to textbox to other multiple sheets 2
Excel TextBox Control 2
Userform textbox string to header causes unwanted double spacing 4
Userform Textbox to Worksheet Textbox 1
UserForm-Insert value from diff worksheet into text box upon initi 3
need help on excel vba please :ActiveWorkbook.FollowHyperlink Address:="TextBox1.Text" 5
Scattered array cells copy to scattered array cells another workbook 14

Top