Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Can you combine Microsoft exel check boxes with a formula?


  • Please log in to reply
1 reply to this topic

#1 hbyton

hbyton

  • Members
  • 196 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:England
  • Local time:03:02 PM

Posted 07 January 2014 - 09:21 AM

Can I have an ifstatement or other formula that will only work if the checkbox is ticked?

 

I want it so that you can only add values to another box (eg a1) if the check box it ticked, is this possible and if so how do you do it?

 

 

 

 



BC AdBot (Login to Remove)

 


#2 Budapest

Budapest

    Bleepin' Cynic


  • Moderator
  • 23,579 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:12:02 AM

Posted 12 January 2014 - 08:54 PM

I haven't really tried this in EXCEL but I believe you could use an if statement like this:

If CheckBox1.Value = True Then

And then use the following code to lock the cells:

Worksheets("Sheet1").Range("B2:C3").Locked = True
The power of accurate observation is commonly called cynicism by those who haven't got it.

—George Bernard Shaw




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users