View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Davies John Davies is offline
external usenet poster
 
Posts: 39
Default 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