ExcelBanter - Textbox value copy from one worksheet to another worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Textbox value copy from one worksheet to another worksheet (https://www.excelbanter.com/excel-programming/407632-textbox-value-copy-one-worksheet-another-worksheet.html)

LRay67

Textbox value copy from one worksheet to another worksheet

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

Linda

JLGWhiz

Textbox value copy from one worksheet to another worksheet

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

Or

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

"LRay67" wrote:

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

Linda

All times are GMT +1. The time now is 02:07 AM.