ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy a Textbox to a range on different worksheet (https://www.excelbanter.com/excel-programming/441836-copy-textbox-range-different-worksheet.html)

LRay67

Copy a Textbox to a range on different worksheet
 
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

Gary Brown[_6_]

Copy a Textbox to a range on different worksheet
 
This is the syntax...
Sheets("Sheet1").Range("C4").Value = _
Sheets("Sheet2").TextBox1.Value

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"LRay67" wrote:

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



All times are GMT +1. The time now is 06:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com