Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm new to Excel programing - have some Access programming. I have a column
that has yes/no boxes in Excel. Is there a way to test the entry to see if it is yes or no? I'm thinking about a VBA If statement. I would select the row and column to be checked and then use the If statement to determine one of two actions to be done. I have tried using the .value with True, False, Y, T, 0, -1, F, and N for the .value being equal to but none of them work. Maybe .value is not the proper value to test? In Access you can test for true or false. There is obviously something that I am totally missing. Any pointers gladly accepted. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can you help test our Excel test? | Excel Discussion (Misc queries) | |||
Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
Test | Excel Discussion (Misc queries) | |||
test..where are my messages..test | New Users to Excel | |||
test | Excel Programming |