mae0429
07-21-2008, 11:25 AM
Hi, I have this crossposted on Mr. Excel:
http://www.mrexcel.com/forum/showthread.php?t=331524
I've got an embedded chart on a worksheet and it has 24 checkboxes (control toolbox, not form) corresponding to different devices. How would I go about linking another checkbox to select or unselect all the boxes?
I know it could generally be something like:
Private Sub checkbox_Click()
Select Case checkbox.Value
Case True
Make all the other checkboxes true
Case False
Make all the other checkboxes false
End Select
End Sub
And how the heck do I refer to the checkboxes?!?:banghead:
Thanks!
-Matt
http://www.mrexcel.com/forum/showthread.php?t=331524
I've got an embedded chart on a worksheet and it has 24 checkboxes (control toolbox, not form) corresponding to different devices. How would I go about linking another checkbox to select or unselect all the boxes?
I know it could generally be something like:
Private Sub checkbox_Click()
Select Case checkbox.Value
Case True
Make all the other checkboxes true
Case False
Make all the other checkboxes false
End Select
End Sub
And how the heck do I refer to the checkboxes?!?:banghead:
Thanks!
-Matt