Sleeper: Checkboxes on worksheet
This may be an easy one?.
I have several checkbox's on a worksheet and I want to display in the cell next to them a value which is based on weather it has been ticked and if so, add 1 to the count of previously checked checkboxes. This is done after pressing a button.
Like so:
Column Ticked? Cell Value
[Checkbox] True 1
[Checkbox] False
[Checkbox] True 2
[Checkbox] False
[Checkbox] True 3
How is this done?
Thanks,
Marcster.
I assume that by " ...add 1 to the count of previously checked checkboxes. ..." you mean the count of all checked checkboxes above at any given time and not the count of all checked checkboxes that have ever been checked?Originally Posted by Marcster
"It's not just the due date that's important, it's also the do date" [MWE]
When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.
Hi MWE,I assume that by " ...add 1 to the count of previously checked checkboxes. ..." you mean the count of all checked checkboxes above at any given time and not the count of all checked checkboxes that have ever been checked?
Anytime the button is pressed (the Cell Value is reset) it will display the results in the Cell Value column.
Marcster.
Decided to do the task a different way.
Posting Permissions
Reply With Quote
