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.
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.