check box

How can I have a checkbox change from unchecked (FALSE) to checked (TRUE) based on a cell value? Thanks everyone.

I have two workbooks (1 and 2) used as a Data gathering report builder and datadase on both sides. On each there is a Checkbox (A and B) (Active X) that is used for the same purpose (to back-date the schedule after midnight [12.00am] and then update the schedule each day after the production has...

Is there a way to use 'check boxes' and have it fit nicely into the cell, instead of having to amnually construct the box? I want to creat check mark boxes next to every item in a list. If tihs is nto possible, I will just use a data validation drop list

I have a sales spreadsheet which has multiple worsheets, one worksheet per saleperson. On each worksheet there are 2 pairs of graphs. The 1st pair is sales performance based on gross revenue and the 2nd pair is sales performance based on net revenue. I have created a template worksheet and...

I am looking for help regarding a check box function. I have a macro that fires when a checkbox is clicked on(to "check" it). The macro unhides a hidden sheet within the workbook. I need the checkbox to not only unhide the hidden sheet, but also to copy certain cells within the Main Input...

I'm extremely new to macros and VBA for excel. With that said I'm excited about the functionality they can offer. I have a complicated (for me) question to ask. I have a workbook with 3 worksheets. One is labeled "main" and is being used as the main input source. The other two worksheets...

I have a sheet that i´m trying to protect and allow users to edit certain ranges, when doing so I can´t unprotect check boxes and option buttons. The cell that they are placed in are unprotected and so are the cells linked to the check boxes and option buttons. Even if I allow to edit the whole...

I'm pretty new to UserForms, so I'm starting simple. I've put 6 checkbox objects on the first page of a MultiPage object. I would like to set the Enabled Property of the second page to "True" only if all the checkboxes on the first page have a value of True. If not, or when one of the...

Yesterday I asked for some VBA for my latest project. It worked :biggrin:GREAT:biggrin:, many thanks. However, the code that is now on the worksheet does slow the sheet down, and also negates any cut/copy and paste commands. So my thought is to add a checkbox that will turn on or off the code...

I have a workbook with 100 tabs and I have an index page with checkboxes for each tab. I need a macro that will clear all of the checkboxes on the page with one button and a separate macro that will print only the checked tabs. Can anyone write that code for me so I can just add it into my...

I have two questions : 1) Can one check box be associated with one cell..? 2) I have a field/column in excel sheet with text. It may contain any text, number, space or no value in this field/column I used =ISNUMBER((SEARCH("NULL",C5,1))) C5 is the cell having text D5 has the above...

I'd like to create a check list in Excel that allows the viewer to manually click on a check box to choose certain options. Can someone help me with how to insert a checkbox? Thank you

Hello, I creating a forum in which i have added a check box but I cannot figure out how to increase the size of text because the one i have right now is very small and I have to increase it, how do i do that?