View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default check box - true/false/na

Maybe you could use a checkbox from the Control toolbox toolbar instead.

Change the triplestate property to true. It seems to react the way you want.

Kelly 1st wrote:

Hello,

I'm putting in a checkbox and have it as a "mixed" value in the control
section.

When it first appears it is greyed out and is has a value of N/a, then you
click and it becomes false, then tick it and it becomes true - when you click
it again it becomes false.

What i would like is it to become N/a again and not revert back to False. Is
it possible to do this in '97?

--
kelly m johnson
London UK


--

Dave Peterson