Finding Text Boxes & Changing its Values using Macros

dineshtendulkar

Board Regular
Joined
Apr 18, 2011
Messages
53
Hi Guys,

Important Help Required: Please reply if you have answers for this.

I have a Two Separate Sheets. In First Sheet Am Having a shape with three text boxes in Cell B2. Each text boxes with a name "TextBox 1", "TextBox 2", "TextBox 3" and a freeform shape with name "Freeform 1".

In the second sheet i wrote a macro to copy the shape from sheet 1 and paste it in the cell S2 if the shape name matches in Cell H2, so it continues till the end.

Now the problem is, The pasted shapes will have the same names in S2, S3, S4.... etc., If H2 is updated in S2 automatically the shape will appear and the three TextBoxes to be linked to cells I2, J2, K2 respectively.

Again if H3 is updated in S3 automatically shape will appear and the three text boxes to linked to cells I3, J3, K3 respectively.

I completed the coding for all. Except these textboxes linking.

Could anyone help please.
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top