Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rng.Offset(-1, 6).value to work with CheckBox value
Code line:
If rng.Offset(-1, 6).Value = Sheets("Inspections").Range("T13").Value Then Range("S13").Value = "TRUE" Else Range("S13").Value = "FALSE" The offset is correct.(-1,6) I have in Sheets("Inspections").Range("T13") a text value of "AAA" and in Sheets("Inspections").Range("S13") a text value of "FALSE" . This value is the linked cell for the Checkbox. I have a total of 4 checkboxes. Linked cells are "S13:S16", and i have 4 text values in the range of "T13:T16" that co-incide wit the linked cells to give a texct value other than a TRUE or FALSE value. In the baove code i get a Ticke box when the text value in T13 = "AAA", which is CORRECT, the Tick is placed in the checkbox because of the range("S13").value = TRUE. BUT, If i change the text value in "T13" to something else, say "ZZZ", i STILL get a checkBox with a Tick. How can i rectify this so i can input values and change the check/uncheck values of the checkboxes ? Corey.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
rng.Offset(-1, 6).value to work with CheckBox value
It worked for me using both types of checkboxes, Forms and Control.
Mike F "Corey" wrote in message ... Code line: If rng.Offset(-1, 6).Value = Sheets("Inspections").Range("T13").Value Then Range("S13").Value = "TRUE" Else Range("S13").Value = "FALSE" The offset is correct.(-1,6) I have in Sheets("Inspections").Range("T13") a text value of "AAA" and in Sheets("Inspections").Range("S13") a text value of "FALSE" . This value is the linked cell for the Checkbox. I have a total of 4 checkboxes. Linked cells are "S13:S16", and i have 4 text values in the range of "T13:T16" that co-incide wit the linked cells to give a texct value other than a TRUE or FALSE value. In the baove code i get a Ticke box when the text value in T13 = "AAA", which is CORRECT, the Tick is placed in the checkbox because of the range("S13").value = TRUE. BUT, If i change the text value in "T13" to something else, say "ZZZ", i STILL get a checkBox with a Tick. How can i rectify this so i can input values and change the check/uncheck values of the checkboxes ? Corey.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checkbox to work when emailed | Excel Worksheet Functions | |||
Checkbox Offset | Excel Programming | |||
How does .offset(i, counter) work? | Excel Programming | |||
Trouble getting the OFFSET fo work | Excel Programming | |||
Simple hiding columns with vba does not work with a checkbox | Excel Programming |