Marcster
08-17-2005, 01:03 PM
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 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.