Triple state command button
I have a toggle button that is linked to a cell that I want to use in triple
state. On the 1st click the cell returns TRUE, on the 2nd click the cell
returns FALSE, but on the 3rd click the cell returns #N/A. How can I get the
cell value to show 100 on the 1st click, 200 on the 2nd click and 0 on the
3rd click.
Thanks in advance of any help.
John
|