Commandbutton backcolor depends on caption

Hi, Everyone!

I'm working on a seat plan project wherein if button was clicked it'll turn to green if the seat was taken however I can't seem to figure out what to do with the update that I need to do.

Example:
Seat 354 was reported that there was an issue with headset it should turn YELLOW IF someone pressed on the seat 354 (if it was reported previously reported that there was an issue) a Msgbox should also show the issue it has however IF it was tagged as resolved already then the button will turn green again IF pressed.

I would really appreciate if someone will help me out.

Hi!
I tried the code however it still stated the issue even though it was tagged as resolved ("YES")
THank you for your help!

it doesn't work on mine. Is it possible if it's due to the version of excel that I'm using?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Kind regards
Leo

sorry for the very late reply. Will tag this as solved. Thank you for the codes!