LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VB's Command Button vs Form's Command Button Ronald Dodge Excel Programming 3 May 24th 06 02:23 PM
Mouse-Over State on Graphic Button TheVisionThing Excel Programming 6 November 18th 05 05:17 AM
triple state button question filo666 Excel Programming 1 May 24th 05 12:15 AM
triple state option buttons Ken Macksey Excel Programming 0 April 13th 05 06:23 PM
state of option button crapit Excel Programming 12 June 3rd 04 10:15 AM


All times are GMT +1. The time now is 01:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"