On/ Off button in VBA

[Raj ASRP]

Hi Everyone,

I need your assistance to build the on and off button macro, here i have attached the sample file for your reference.

so when I click the “On” button the off will hide and the range will be select in A1 is 1 or true, likewise if I select “off” button the entire oval shape should be in off. Help me to fix this.

Thank you
Raj

[jolivanes]

Both are named the same. Maybe try giving them different names first and see how far you get.

[jolivanes]

You don't want to have just a single button changing text?
A lot easier to maintain/change. Certainly in the future after you forgot what you had done to make it work.

[Haluk]

Another alternative is attached;

.

[Raj ASRP]

Thank you so much Haluk and Jolivanes ... have a wonderful day ahead...be safe....

Thanks
Raj