Daren has attended:
Excel VBA Intro Intermediate course
Check Boxes
In Excel, Can Check Boxes be made to work in the same way as Option Buttons
i.e. in a row of 3 check boxes, only 1 can be ticked at any one time.
If one of the boxes were ticke it would give a True or false answer
Or is there a way that this can be controled in VB.
RE: Check Boxes
Hi Daren
Thank you for your question
The easiest way would be to write an after update event for each check box, whereby if that check box's value is true, then the values of all the other check boxes are set to false.
On this basis, as soon as you ticked a check box the code would remove any ticks from the other check boxes.
Regards
Stephen
RE: Check Boxes
Hi Stephen
Thank yor for you help, this does sound like what I need to do.
I have tried looking throught the hlelp menus and can find referance to the after update event, but connot workout out how to write
could you tell me how I would wirte this
RE: Check Boxes
Hi Daren
Sorry for the delay in responding
Each combo box would have an after update event associated with it, each time the code would set the other combo boxes equal to false, so;
Sub ComboBox1_(After Update)
ComboBox2.value = False
ComboBox3.value = False
ComboBox4.value = False
ComboBox5.value = False
End subHope this helps
Regards
Stephen
