Is there a way to set the text/name of a button so that it toggles between two values each time it’s pressed?
Is there a way to set the text/name of a button so that it toggles between two values each time it’s pressed?
Try this.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Outstanding...thanks
A follow on question...if I have a cell that references a worksheet by the same name as the caption (i.e. ='Caption1'!A1) how can I use that button and the change in caption name to also change the cell reference to (i.e. ='Caption2'A1)
To be fair, I ought to close this post as solved. I have taken this great advice and this does just what I needed, thank you very much.
The second part of my question I have posted as part of another question I had.
http://www.excelforum.com/excel-prog...reference.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks