PDA

View Full Version : on change event according to pivot table



tommy1234
03-27-2011, 10:42 AM
Hello
i need to update text inside a shape.
the value for the text is taken from a pivot table
i want to update the text inside the shape each time the pivot is change.

ActiveSheet.Shapes("Lines").Select
Selection.Characters.Text = Worksheets("Pivot").Range("d79").Value


thanks

Jan Karel Pieterse
03-27-2011, 09:57 PM
Can't you just have the formula of the shape point to that cell?