Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help!checkbox relative reference
I have about 400 checkboxes on multi tabs of a multi tab control.
They are named/set up as follows: CheckBoxA CheckBoxB CheckBoxC CheckBoxD CheckBoxE CheckBoxF..... I set up code to ensure that if CheckBoxA is Checked, CheckBoxB and will be unchecked etc. (see below) My problem is, I don't want to write code for each CheckBox's OnClic Event. I want to know if there is a way to reference the CheckBoxe around the current checkbox using some type of relative reference. My current code is: Private Sub CheckBoxA_Click() If CheckBoxA = True Then CheckBoxB.Value = Not CheckBoxA.Value CheckBoxC.Value = Not CheckBoxA.Value End If End Sub If anyone can help me modify this to make my life easier, I would b sooooo appreciative. Thanks -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
relative reference | Excel Discussion (Misc queries) | |||
Relative Reference | Excel Discussion (Misc queries) | |||
relative reference | Excel Programming | |||
relative reference | Excel Programming |