I have 30 buttons that I want to toggle between YES and NO when pressed. Is there a single code to apply to each button to accomplish this, or must I continue copying and modifying the same code for button as I have been? I keep thinking there must be an easier way, but it is escaping me at the moment.
Looking for a single function to change the captions for numerous toggle buttons
-
-
-
Re: Looking for a single function to change the captions for numerous toggle buttons
Where are these buttons located?
-
Re: Looking for a single function to change the captions for numerous toggle buttons
My apologies. The buttons are controls on a spreadsheet, indicating whether or not a piece of equipment has been checked on a given day of the month. I put toggle buttons to make life a little easier for the intended users.
-
Re: Looking for a single function to change the captions for numerous toggle buttons
Why not just use checkboxes or option buttons?
Could you attach an example workbook?
-
Re: Looking for a single function to change the captions for numerous toggle buttons
Largely because I could change the size of the toggle button, but I was less successful at making the checkbox or radio button appear on the sheet at a size I wanted. The fill is too big to attach, but I mocked a version of it to show you. The B's indicate where buttons are intended to go.
-
-
Re: Looking for a single function to change the captions for numerous toggle buttons
So why not use Marlett Font and small a to create ticks (checks)?
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!