ExcelBanter - Linking Text boxes on worksheets???

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

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

- - Linking Text boxes on worksheets??? (https://www.excelbanter.com/excel-programming/281569-linking-text-boxes-worksheets.html)

No Name

Linking Text boxes on worksheets???

Is it possible to (using a macro) to set the value of one
text box on Sheet 1 to be the value of another text box
on Sheet B?

This seems like it should be very simple to do but i
can't figure it out.

Jeff

kotharu[_6_]

Linking Text boxes on worksheets???

its very simple jeff..

its looks like

sheets("Sheet1").text1.text=sheets("Sheet2").text2 .text

regards
kotharu

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

All times are GMT +1. The time now is 03:41 PM.