View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default Select one checkbox to Deselect another

using control toolbox checkboxes, i put them within _click events
(when they get checked):

Option Explicit

Private Sub CheckBox1_Click()

CheckBox2.Value = False
CheckBox3.Value = False

End Sub
==========================
Private Sub CheckBox2_Click()

CheckBox1.Value = False
CheckBox3.Value = False

End Sub
=========================
Private Sub CheckBox3_Click()

CheckBox1.Value = False
CheckBox2.Value = False

End Sub
=========================
did one for each checkbox, as mentioned previously.
hope it helps.
susan


On May 19, 1:06*pm, Susan wrote:
if checkbox1.value = true then
* *checkbox2.value = false
* *checkbox3.value = false
end if

if checkbox2.value = true then
* *checkbox1.value = false
* *checkbox3.value = false
end if

if checkbox3.value = true then
* *checkbox1.value = false
* *checkbox2.value = false
end if

like that
hth
susan

On May 19, 9:35*am, Keith74 wrote:



Yes, it's completely possible. You just have to add code to pick up
when the value of a checkbox changes and reset the other checkboxes.
Theres loads of code samples on the web.- Hide quoted text -


- Show quoted text -