Changing button colour/properties on click

[CaptFirePanda]

Hi all,

I'm setting up a dashboard with buttons to display chart data based on the selected button. I've been using the solution provided by smozgur laid out here: https://www.mrexcel.com/board/threads/change-button-color-upon-click.1173075/post-5715010

I'm running into an issue where I can get most of the buttons to do what I'm hoping they will do. The only exception is the "Oil Consumption: South East Asia" button - when I click it, the LNG Imports: South East Asia button changes instead.

I've named all of the buttons and grouped the LNG and Oil buttons into separate named groups. I've also built separate macros for each of them. Attached is what I've done for the Oil buttons - the LNG macros are set up in the same way.

It would be great if someone can see what I'm missing or have done incorrectly. I'm still a novice with VBA so I'm sure that I've made a fairly simple mistake but don't have the experience to identify it. Also, I'm comfortable with smozgur's solution so there's no need to develop a better solution unless it takes minimal effort on your part.

Thanks in advance.

 

[James006]

Hi,
The very first thing to do is to go and check the exact name of each and every one of your shapes, since a tiny mistake can disrupt your code ...

 

[CaptFirePanda]

Hi,
The very first thing to do is to go and check the exact name of each and every one of your shapes, since a tiny mistake can disrupt your code ...

Wow... after painstakingly going through them a few times now, I discover that the "Oil Consumption: South East Asia" button name was wrong. Not sure why I didn't catch it previously.
Anyway, thanks for the advice, James!

 

[James006]

You are welcome.

Glad to hear you have managed to fix your problem