Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Triple state command button
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB's Command Button vs Form's Command Button | Excel Programming | |||
Mouse-Over State on Graphic Button | Excel Programming | |||
triple state button question | Excel Programming | |||
triple state option buttons | Excel Programming | |||
state of option button | Excel Programming |