Re - NAME - ing shapes on chart

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

Hi all,

In one large workbook I have 8 charts.
On each of these charts I plot from 2 to 5 series of data.

I have created a button on each chart that when pressed, cycles data point
values either above the series plot line, below the series plot line or off.

Each time it cycles, the text on the button cycles as well from 'Above' to
'Below' to 'Off'.

With that background, here is my problem....

Each button is given a generic name, ie. 'Button 56' and if I refer to the
button with my macro by its name (in order to check its text status and
cycle its text) I will need to have a distinct macro for each button (24 in
total) which is hardly good practice.

What is the best way for me to refer to each, 'just pressed' button with the
macro ?

Is there a 'with current selection' style method that can apply to a button
just clicked ?

Thanks,

Neil
 
Use the caller property - it returns the name of the button

Dim btn as Button
set btn = ActiveChart.Buttons(application.Caller)
msgbox btn.Caption
 
Back
Top