Chart Value Changes in VBA

[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

 

[Earl Kiosterud]

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.