Hi John,

Indeed the toggle button (controls toolbox) doesn't appear to trigger an
event on it's third state. However as the linked cell changes to #N/A with
the linked cell in B14 the following returns your set of values

=IF(ISERROR(B14),0,IF(B14,100,200))

Regards,
Peter T

"John Davies" wrote in message
...
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