View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Kevin Beckham Kevin Beckham is offline
external usenet poster
 
Posts: 78
Default Follow up on this

Tom's code should be in a subroutine named
checkboxJL_Change

On the form, select the checkbox, right-click and select
View Code then select Change method instead of the default
Click method

Kevin Beckham

-----Original Message-----
Jenn,
That sounds correct to me. So if the checkbox is false

then the optionsbuttons stay grayed out correct? If that
is the case then that is what I want to do. However I have
never used a triple state and do not know how this is
done. If you could help me out that would be great.

TIA

----- Jenn wrote: -----

Steve,

I am not exactly sure what you want to happen, but I

think you have 2 options. If the optionbutton is disabled
the button is grayed out or you should explore setting the
triplestate property. When the triplestate property is set
correctly the optionbutton can have a null value.

Jenn
.