check box

I have =CUBEVALUE() functions referencing twenty Lists created with Data Validation (Bolded below). =CUBEVALUE("ThisWorkbookDataModel",$B$2,$B$3,$B$4,$B$5,$B$6,$B$7,$E$2,$E$3,$E$4,$E$5,$H$2,$H$3,$H$4,$K$2,$K$3,$K$4,$K$5,$N$2,$N$3,$H$7,$A$1,$A12,B$11) The limitation is that only one value per...

Hi there, I have a series of checkboxes linked to cells in a row (A2, B2, C2 etc. up to U2) and if a check box is ticked then the corresponding cell = "True", if the box is not ticked then = "False" What I'd like to do not is use the call values of "True" or "False" to Hide/Unhide Rows...

Trying to get a check box, which is linked to the cell concealed behind it, to have conditional formatting so that when the check box is clicked the value 2 cells to the right (which is a partial string) will be highlighted throughout the schedule. I was thinking this could be done by having...

Firstly of all I want to say hello. I've been a regular lurker around the forum and found the content here invaluable. I've come across a problem that has required me to sign up and ask a question of my own now though. I did a forum search and found a similar topic but unfortunately there...

Hello, :confused: I would check a cell with 2 text rows: - each row length must be max 25 digits long - I need a warning or highlight or cell fill in case one row exceed the max length I have set the data validation to check max length, non considering the row Could someone help me? Thanks...

Hi, I can't seem to find a previous post close enough to what I'm trying to accomplish. Also, I don't know if this is possible with Excel formulas or if VBA must be used as well. Below I have an API that shows stock prices, volume, etc. Columns J and K have Combo Boxes and column N has Check...

Ok, this is my first post. I have been able to use the forum to fix my issues with VB until this one. Basically I would like a macro to decide which email, subject, and body content based on whether or not a check box is checked. For instance: Checkbox checked -> sends email to abc@abc.com...

Hello, I am using the code below to add check boxes to column D when column C is populated. I would like these check boxes to disappear when cells in column C are blank again. Although the check boxes appear I am unable to make them disappear when column C goes blank. Please help what I am doing...

Good Day, I'm trying to make it so that some cells are just check boxes. It's a spreadsheet that is going to be having the data manually keyed in so I was wanting to set up the check box so that I can hit Tab and it will move me to the check box just like a normal cell. Then hitting spacebar...

Hi Guys, I have a dropdown list for which I want the user to select from, however, if the user selects something on the list, I want to then show a number of checkboxes. How would I do this? What would the code look like? Many thanks

I want to create a drop down or a check box where there will be multiple predefined options along with enter text option if none of the predefined data is matched. I can create the drop down using data validation or the check box with VBA, but cant find a solution how to add the option to enter...

Hello, I am using check boxes to create a score card for a training activity. I have assigned each check box a value using the below formula, however I need to add to it in order to total all values for check boxes clicked on in a single row. Any help would be much appreciated. Thanks! My...

So I am doing an excel project for my accounting class and I have a check box for my income statement that changes the currency of the values when clicked. There is also a combo box on this sheet that allows me to show nothing, the income statement I mentioned, a balance sheet, and a cash flow...

I have seen a few tutorials that show how to select all check boxes by selecting a single check box, but I am trying to perform this action by clicking a button and am struggling to adapt the instructions. Also, I would like to perform this action only on check boxes where the related row is not...

Hi All, I am working on vba code and not able to get out of one problem. Below is my problem. I have created two user form 1) Combo box 2) Check box(I have created 3 check box based on combo box values) Now, I need that I run macro and it gives me first combo box and when I select value from...

Hi all, Thanks for reading. I have what I think is a very easy issue (annoyingly I cannot seem to solve it :(). I have some code that works and resets all my checkboxes in my worksheet, and now I've got another worksheet that I would like to split out resetting different columns. This way I...

Hello Everyone, I've been struggling with this for a while now, so i realllyyyy hope someone can help! I have this code Private Sub CheckBox1_Click() If OptionButton1.Value = True Then Sheets("Sheet1").Select Range("J4").Select Selection.FormulaArray =...

How to change the value of list, Based on Check Box selection? i have a check box, based on the check box selection, how to change the list value automatically?

Hi, I have data in sheet1 and check box in column A against each line. I want to copy the data in next sheet when check box is checked, however the code that I have works only for each check box and it is a very tideous procedure and it doesn't really help much. What I want is a code that...

Good morning, Operating System: Windows Vista, 7, 8. Excel Version: 2010 I am new to the forums here, and have been working on a spreadsheet which users would input time on and would also act as a cumulative time card. I have so far had a fair amount of luck with creating a spreadsheet that...