checkboxes

Hello all, I have two worksheets, TW and PP. In TW there is a userform that contains a variety of checkboxes, these determine the information I want to take from PP. There are 12 checkboxes for each month of the year, then four category checkboxes. As an example, if I select CBJAN, CBFEB...

I have a UserForm that has several "extra" checkboxes. These checkboxes are enabled in some scenarios, but I use an IF statement to hide them most of the time, based on what is going on in the worksheet. I have the checkboxes functioning properly, but because hiding them leaves a lot of empty...

Hi folks I have a simple UserForm which has 3 checkboxes. Checkboxes labelled "Good" , "Average" and "Bad" When "Good" is checked, the value "1" is entered into a cell. If "Average" is checked then the value "0.5" is entered and "0" is entered when "Bad" is checked. The problem is this......I...

Hello Excelgurus, I've incorporated a bunch of checkboxes in my workbook. The captions of those checkboxes are the first names of staff members. I've added those checkboxes manually and I also manually changed the caption to that particular person's first name. I was wondering if it's possible...

Hello! How are you all? Well, I have a problem, so let me first try to explain myself. I have a Table with a long list of items in Column A and I am trying set two Checkboxes in Column B and C. I found there is two ways to do this: with Form Controls and ActiveX. But they both have differents...

Hi guys, I have a few questions about checkboxes... this is my first time working with them within a UserForm and I'm not 100% confident I know what I'm doing :eeek::oops: A bit of background, I am creating a spreadsheet for recurring invoicing for trees; oaks, elms, you name it, we've got it...

I was sent a file and the creator has a few lists included in the sheet. The instructions state that I cannot make any changes to the form itself except my input, and I need to click on the square to make my selection. Unfortunately, I do not see a square or anything that looks like a control...

I have 5 categories, each with a number elements, and each element has a check box linked to a cell. Can I create a 5 master check boxes, each to link to all the elements in a given category? I have been able to figure out how to link the master to ALL checkboxes in the active sheet, but not to...

I have a worksheet with a multipage object. On each page I have a series of frames, and within those frames a series of checkboxes. Is there a way that I can set the lock properties for all the checkboxes of all the pages without having to set each one on their own? Each of the pages has 50 or...

When I lock my worksheet, the form control checkboxes can't be checked or unchecked, even when the cells they are in are unprotected. However I can when the actual checkbox is unprotected. Just takes too many steps (rt click the checkbox, open form controls, uncheck the "locked" in the...

Hello guys, I've written some VBA to control some checkboxes but it's causing an issue that I can't quite get my head around fixing and was wondering if anyone here had any ideas. So basically I have a stacked bar chart. I have a list of options (about 20) that can be individually clicked to...

Hi there I manage tocheck or uncheck all checkboxes in my sheet. However, what I need to do is checking and unchecking all checkboxes in a range, eg B5:B17. Any help would be appreciated. Thanks

Hi Guys! I'd like to understand how to get a result for the below example situation: I have a list of 10 people names linked to 10 different checkboxes. What I want to obtain is that when I check 8 of these checkboxes, the result will contain the names of the 2 people I haven't checked the box...

I am trying to set the following VBA to prevent save if any checkboxes are empty. Any help is great. Private Sub dontsave() If Sheets("Sheet1").Range("A3") = "" Then Cancel = True MsgBox "Save cancelled" End If End Sub

Thx for stopping by my post. I'd be so appreciative if someone can tell me how to make a drop-down box (in one cell), where there's a checkbox before each selection, and most importantly, I can check off multiple items. thx for ur time and ur help

Hello everyone, I am having an issue with ActiveX Checkboxes but I don't know what the problem is or how to fix it. So I have a sheet like this: [/URL][/IMG] And I have a code running to make everyone in column B have their own sheet. However, I only want that to happen if the checkbox in...

Hi I have searched youtube for the answer to what i hope is a simple question. I have 6 checkboxes on an excel sheets, i want a bunch of rows beneath those checkboxes to unhide but only if All 6 of the checkboxes are ticked. Thanks in advance

I have to solve a big problem. I have a recorded grouped object. It consists of a lot of checkboxes with code behind all of them and 10 buttons. I have it by userform command copy and pasting to another worksheet in the workbook. It is an option for editing the cells it will cover. Problem is...

I am not sure if this is possible, but it seems like theoretically it could be done. I am trying to create a Macro that pops up a userform with a list of courses. Once the user has selected the relevant courses and started the generation process, I would like for the code to be able to first see...

If have 20 specific activex checkboxes and would like to loop thru them to set to TRUE versus one by one. How do I convert .CheckBox1 = True .CheckBox2 = True .CheckBox3 = True .CheckBox4 = True to for i = 1 to 20 .Checkbox & Cstr(i) = True next i At least that was my attempt.