JSA715
08-04-2008, 03:45 PM
I have a list of control checkboxes on a form within a frame, Alpha - Delta, and a checkbox by itself, Zulu. I need an efficient script that will do the following.
Private Sub Alpha_Click()
If Zulu.Value = True Then
if alpha.value = true then
bravo.value = false
bravo.enabled = false
charlie.value = false
charlie.enabled = false
delta.value = false
delta.enabled = false
Elseif alpha.value = false then
bravo.enabled = true
charlie.enabled = true
delta.enabled = true
end if
end if
They will work like normal check boxes until Zulu is set to True.
Once Zulu is set to true, all boxes are set to false, then if one box is set to true, the rest are disabled. If that same box is set back to false, the rest are enabled and set to false.
Im extremely new to VBA and am just having to pick it up as needed. In reality, I have about 20 of these boxes needing different combinations of this formula. Can anyone point me in the right direction?
Private Sub Alpha_Click()
If Zulu.Value = True Then
if alpha.value = true then
bravo.value = false
bravo.enabled = false
charlie.value = false
charlie.enabled = false
delta.value = false
delta.enabled = false
Elseif alpha.value = false then
bravo.enabled = true
charlie.enabled = true
delta.enabled = true
end if
end if
They will work like normal check boxes until Zulu is set to True.
Once Zulu is set to true, all boxes are set to false, then if one box is set to true, the rest are disabled. If that same box is set back to false, the rest are enabled and set to false.
Im extremely new to VBA and am just having to pick it up as needed. In reality, I have about 20 of these boxes needing different combinations of this formula. Can anyone point me in the right direction?