Chart Value Changes in VBA

  • Thread starter Thread starter John
  • Start date Start date
J

John

When you have say a bar chart and drag the bar downwards this will change
the value in the reference source cell. Is there a way through VBA to
identify the source and the cell changed by when dragging the bar. That is,
when you drag the bar in the chart let me know the cell that ahs changed!

Any help would be appreciated. Thanks in advance.

Howard
 
John,

If your objective is to prevent the cell changes via the chart, you can
protect the worksheet (Tools - Protection). The cells should be locked
(Format - Cells - Protection).

Or you can use the Chart_SeriesChange event macro for the chart sheet. It
will tell you which series, and which point of that series was changed.
From that, you can determine the cell affected, per the chart's source data
references.
 
Back
Top