I am trying to setup a Toggle button to change its "caption" when enabled disabled. I have the true false linked to Cell T2 and have the cells I need to change all setup to work with cell T2 cycling between true/false.
What I would like to happen is when the button is clicked the caption changes and if possible the background colour change.
My initial thought was to use the linked cell (T2) in the buttons VBA code to satisfy a If statement. But I dont know how to put this into practice.
(BTW I enjoy learning how to code works more than just having someone post a bit of code.)
Thanks.
Bookmarks