98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Check Boxes
Check Boxes
Resolved · Medium Priority · Version 2003
Mon 8 Jun 2009, 18:02Delegate Daren said...
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.
Wed 10 Jun 2009, 11:09Trainer Stephen said...
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
Thu 11 Jun 2009, 15:12Delegate Daren said...
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
Fri 26 Jun 2009, 14:32Trainer Stephen said...
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
Fri 3 Jul 2009: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Manually wrapping textTo manually wrap text, use the shortcut key Alt+Enter. |
