Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using contents of a check box for an in statement
I would like to create an if statement that could somehow read whether or not
a check box is checked. I'm pretty familiar with Excel programming, but not much beyond that. I would like to do something like if(checkbox=true, 15). Something like that. Does anyone know if I have any options? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using contents of a check box for an in statement
Erin,
If you're doing this IF in a formula on the worksheet, then set the cell link for the check box (it's in Format). Then test that cell: =IF( A1, "it's checked", "it ain't") -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Erin" wrote in message ... I would like to create an if statement that could somehow read whether or not a check box is checked. I'm pretty familiar with Excel programming, but not much beyond that. I would like to do something like if(checkbox=true, 15). Something like that. Does anyone know if I have any options? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using contents of a check box for an in statement
I don't see an option under Control Format for linking a cell. When I right
click on the check box and open Properties, I see "LinkedCell" in properties for the check box. Is that what I use? Would I have to do that manually for each check box? Thanks for your help! "Earl Kiosterud" wrote: Erin, If you're doing this IF in a formula on the worksheet, then set the cell link for the check box (it's in Format). Then test that cell: =IF( A1, "it's checked", "it ain't") -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Erin" wrote in message ... I would like to create an if statement that could somehow read whether or not a check box is checked. I'm pretty familiar with Excel programming, but not much beyond that. I would like to do something like if(checkbox=true, 15). Something like that. Does anyone know if I have any options? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using contents of a check box for an in statement
There's a checkbox on the control toolbox toolbar and a checkbox on the Forms
toolbar. Each works differently. Earl guessed that you used a checkbox from the Forms toolbar. But you used a checkbox from the Control toolbox toolbar. You can either use the linkedcell (just type in that address) with the checkbox that you used or you could delete that checkbox and replace it with one from the Forms toolbar and use Earl's suggestion. Erin wrote: I don't see an option under Control Format for linking a cell. When I right click on the check box and open Properties, I see "LinkedCell" in properties for the check box. Is that what I use? Would I have to do that manually for each check box? Thanks for your help! "Earl Kiosterud" wrote: Erin, If you're doing this IF in a formula on the worksheet, then set the cell link for the check box (it's in Format). Then test that cell: =IF( A1, "it's checked", "it ain't") -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Erin" wrote in message ... I would like to create an if statement that could somehow read whether or not a check box is checked. I'm pretty familiar with Excel programming, but not much beyond that. I would like to do something like if(checkbox=true, 15). Something like that. Does anyone know if I have any options? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check for repetition of cell contents | Excel Worksheet Functions | |||
Check cell contents before print | Setting up and Configuration of Excel | |||
Fussy check of cell contents | Excel Discussion (Misc queries) | |||
how do i create a macro that would check the contents of cells | Excel Discussion (Misc queries) | |||
IF statement to check cell contents | Excel Worksheet Functions |