View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Clearing Check Boxes & Running a diff Macro when unchecking the ch

hi
in each checkbox you will need code like this.
Private Sub CheckBox1_Click()
If CheckBox1 = True Then
CheckBox2 = False 'all the others = false
CheckBox3 = False
'Call macro1 'call a specific macro for this checkbox
End If
End Sub
I only did 3 check boxes to test but you will need to list all of them as =
false.
each check box needs code that if checked(=true) then uncheck(=false) all
the rest then call the specific macro for that check box.
make sence?

post back if confused.
Regards
FSt1

"Vick" wrote:

Ok, I'm using the Control check boxes. I have 6 of them. On each of the 6 I
have assigned a Macro to do something on the page. I have 2 problems.

1)I want to make so that only one box can be selected (Not sure if there is
a way to do that or have a macro to clear the rest of the check boxes)

2) I want two different actions when the box is unchecked. Right now the
macro runs when I check or uncheck the box. I would like one macro to run
when I check the box and one to run when I uncheck the box. Is there a way to
accomplish this?

Thanks