How can I put the value of Sheet2 Range A1 and A2 into a text box control in Sheet1?
So that, whenever I update the value of Sheet2 Range A1 and A2, the value of text box will also be updated. Thank you
How can I put the value of Sheet2 Range A1 and A2 into a text box control in Sheet1?
So that, whenever I update the value of Sheet2 Range A1 and A2, the value of text box will also be updated. Thank you
One way is to put the following code on the Sheet2 Module.
Right click the Sheet2 Tab --> View Code --> Paste the following code into the opened code window --> Close the VBA editor --> Save your workbook as Macro-Enabled Workbook.
For details, refer to the attached.Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Hi! thank you for the help. I would also like to put the value of Sheet2 Range A1 and A2 into the same text box. and also the value of Sheet2 Range A2 and A2. so on and so forth. up to Sheet2 Range A12 and B12
But I would like them to appear like this
Example
Sheet2 Range A1 and B1
Sheet2 Range A2 and B2
Sheet2 Range A3 and C3
For every row, they would appear on the next line. Please help. thank you
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
thanks, it worked. I also did click the * button
Instead of starting at A1, I want to start at A2, but when I replace the value
If Not Intersect(Target, Range("A1:B12")) Is Nothing Then
to this
If Not Intersect(Target, Range("A2:B12")) Is Nothing Then
why is it copying the value of Sheet2 Range A1?
First of all thanks for the rep.
About your question.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks