Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox true/false label
Hello,
I want to change the "TRUE" and "FALSE" labels that pop-up in the cell linked to the checkbox with "YES" and "NO," respectively. I am using checkboxes from the control toolbar. These are the TRUE/FALSE labels that appear when you tick the checkbox. I'm sure its one or two lines of code, just can't seem to find it. Thanks for the help, jashby2 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox true/false label
No really practical to do it with code I wouldn't think. Link the cell
underneath the checkbox. Then in the cell where you want to see yes/no, put in a formula =if(A1,"Yes","No") where A1 is the linked cell. -- Regards, Tom Ogilvy wrote in message oups.com... Hello, I want to change the "TRUE" and "FALSE" labels that pop-up in the cell linked to the checkbox with "YES" and "NO," respectively. I am using checkboxes from the control toolbar. These are the TRUE/FALSE labels that appear when you tick the checkbox. I'm sure its one or two lines of code, just can't seem to find it. Thanks for the help, jashby2 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox true/false label
Wow thanks for the quick reply.
Seems like a good method. But more like, =if(A1="TRUE","Yes","No") I may need quotes around the TRUE part. Very cool, thanks, Jason |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox true/false label
But more like,
=if(A1="TRUE","Yes","No") If A1 is True or False, (and it is) then what I gave you is sufficient. A1="True" will convert either "True" to the boolean value True or Change the Boolean Value True in A1 to "True" to do the comparison and then return the boolean value True. Sounds like the long way around the block when A1 already contains a boolean True (or False) To summarize if that wasn't clear - you don't need to change anything I provided. -- Regards, Tom Ogilvy wrote in message oups.com... Wow thanks for the quick reply. Seems like a good method. But more like, =if(A1="TRUE","Yes","No") I may need quotes around the TRUE part. Very cool, thanks, Jason |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox true/false label
Okay, very true. I'm new to vba, so elegant solutions are still
foreign to me. Thanks for the help, Jason |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox true/false label
Just for clarification:
That isn't VBA, it is a worksheet formula. You should place it in the cell where you want the Yes/No. -- Regards, Tom Ogilvy wrote in message oups.com... Okay, very true. I'm new to vba, so elegant solutions are still foreign to me. Thanks for the help, Jason |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox true/false label
Alright, sounds good. I am creating rows dynamically based on form
data, so I will assign the above worksheet formula to a cell via VBA code. So I was thinking "behind the scenes." But you are right it still is a worksheet formula. Go skins! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
I need to create a simple checkbox that has true false outputs | Excel Discussion (Misc queries) | |||
Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
Checkbox toggle true/false | Excel Programming | |||
True Or False, no matter what... it still displays the false statement | Excel Programming |