View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Earl Kiosterud Earl Kiosterud is offline
external usenet poster
 
Posts: 611
Default 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