checkboxes

Greetings everyone, I have one final thing that I am trying to do on what will be a shared Excel file to prevent others from potentially changing or manipulating the information that is being entered. I have a list of requests that come through and each line gets a checkbox added. When this...

Hi everyone, I'm fairly new to VBA so this doesn't seem obvious to me at the moment. I've managed to use Checkboxes to copy the rows that have a check mark from sheet1 to sheet2. The problem is that if I insert a new row in sheet1 somewhere in the middle of the worksheet and I insert a...

Hi, I need some help with hiding checkboxes. I have a macro running that hides specific columns (containing checkboxes) according to specific criterias. Criterias in checkboxes in column A Then in Column B,C,D and E other checkboxes According to the selections in the checkboxes in column A...

Apologies for the basicness (if that's a word) of this query... but I'm a VBA virgin... I have a spreadsheet that I've designed as a questionnaire to determine the level of complexity of a project - various questions are asked with the answers weighted to provide an overall score that...

when I hide a column/row contains checkboxes, the checkboxes won’t be hidden with the row/column and they overlapped with the content of other row/column:( how can i solve this

Good evening, I have the following code in a userform to automatically take what the operator has selected from a choice of checkboxes and puts the caption value in a textbox. However I have other checkboxes in the userform and it is picking up all of the checkboxes. Is there a way to make it...

Hi All, I would like to select two checkboxes and run a macro, e.g. I have two checkboxes 1 call ChkBoxCarrA & a 2nd called ChkBoxCarrB. If I only select ChkBoxCarrA it calls a macro to produce a graph, If I only select ChkBoxCarrB it calls a different macro to produce a graph. I want to be...

After closing the UserForm and reopening it, I'd like for it to reflect the checkboxes that were previously checked for that cell. As of right now, it does return the value of the last checkbox, but not the rest. Can anyone help? Thanks. Private Sub UserForm_Initialize() Dim n...

Hello, everyone! I'm trying to make an user form for someone to select a date, number, and status (using checkboxes). Option buttons work fine, but now management wants to have the ability to select more than one. I'm trying to think of a way to do that, but I'm not sure how it would be...

Hi All, I am new to VBA so please excuse any silly questions. I have a worksheet with a list of customers in range F20:F169 when you double click in the adjacent cells (range G20:G169) it generates the same userform with 25 checkboxes for all 149 customers. Is it possible to save the...

Hi All, I have data in row a1 thru a100. I need to insert checkboxes that will allow me to sum only the items that are checked. Using the developer TAB I enter a checkbox, press Enter and copy fill it down. This inserts 100 checkboxes. Is there a smart way for me to format control, and assign...

I was given a project and the prior person put check boxes on top of check boxes. Is there away to find the boxes that have other ones under them? Also when I hide the rows that have check boxes on top of them, the boxes get all goofed up. Is there away to hide rows with check boxes and unhide...

I am new to macros and VBA, so please type slowly. I am trying to use a checkbox (true/false) as a trigger element to call one of two Macros (Hide and Unhide a column). When false, I want the column hidden. When true, I want the column unhidden. I will need a total of 9 checkboxes and columns...

I'm putting together a nutrition spreadsheet and I want to be able to click on checkboxes in rows and have the info (proteins/carbs/fats) be added or removed from a running total for that day. Any food that will make me go over the limit on any of the 3 areas I want to have removed from the...

I put together a userform that uses a lot (100+) of check boxes, I have made off the names match what I need them to do but I didn't change the caption to Blank...before I stated to copy Is there a way to change all checkboxes caption to " " Userform name is "LoadMaps" Thanks in advance!

Hi there again, I am trying to stabilize a process internally and this in part, is to create specific folders (on a network drive) based on the checked box values from my User Form. Each project we do may or may not need a folder to maintain working files and instead of adding empty folders...

Hi, I've tried with this the best I could but I'm failing, I'm hoping some vba whizz can help me out, Its not letting me attach a workbook here so I hope pictures are ok to describe but please come back to me if its not making sense. I have a workbook called SWMS with two tabs, Template &...

What I want to do is: If the checkbox in cell X1 is true then copy cell X2 and then paste in Cell X3 but only if Cell X4 is equal to todays date. If it's not todays date then check cell Y4 for todays date. If not then check cell Z4... And so on until the cell with todays date is found. So if...

Hi I am a newbie to <acronym title="visual basic for applications">VBA</acronym> coding in Excel and this one is just too complex for me to get my head around with userforms and combining checkboxes etc, so reaching out to this great forum I have had so much success with :smile: When you...

What I am trying to do is add up all the prices when the paid checkbox is ticked and the just eat checkbox is ticked. I just can't seem to get to grips with it. I'd also like to be able to say how many just eat are paid and how many are not paid but again I keep getting errors when using the...