checkbox

Hi, I'm trying to find a macro code to hide/unhide certain/selected cells only using the checkbox. For example, if I tick the checkbox, it will show cells "A4:D9" but when I unchecked it, the mentioned cells will be hidden. Attached is a sample of my query. The shaded parts are the ones...

Hello, excel gurus, So, I have a vba code that checks every checkbox that i have in a table, and deletes said checkbox if the row is empty or outside of the table, but I had to put a "+8" in the row range, because the table starts at row 7 of my worksheet. Problem with this, is if someone make...

I've got a spreadsheet where I enter some amount in one currency and it's converted automatically into another using a web linked exchange rate in the formula. I then want to lock the results converting the formula into value by checking a checkbox in the same row. So I need to link the cells I...

Hi Guys, New the threads, so thought I'd give it a go. I'm stuck, I'm creating a workbook that we use for our tender submissions. What I now want to do is when a check box is ticked i want to move that row to another page (not the whole row - i.e. only move a5,b5,c5 across to another...

Hello everyone! I have a huge problem. we utilize a "to-do" list with checkboxes that are inserted into each new sheet with the following code: Sub InsertCheckBox() Dim rng As Range Dim chkBox As CheckBox Dim cell As Range Dim i As Integer ' Set the range where you want...

Hello, Calling all help! I cannot figure out a formula to make this work. I am tracking my pups got their medical history and I would like it to auto-give me a expiration date based on the most recent date i entered where its checked (I added checkboxes into columns- not sure if that is a good...

Hi all, I have a useform with a couple of checkboxes on it. Upon activating the userform I would like to run a couple of checks on the checkboxes. I want to use a private sub for that and pass the checkbox as an object into that sub, but no matter how I do it, I get an error 424 Object...

Hi I am not sure if this is possible.... I presently have a userform and within the userform, the user can check a checkbox to say that a process has been audited. I would like to control the users that can actually insert/remove a checkmark from that checkbox. The person would click on the...

I have over 100 activeX checkboxes on a sheet. Some of the checkboxes are already checked/unchecked so I want the macro to ignore those. I found a macro to change all checkboxes to false but I'd like to modify the code to only change the value to False if the Value field in the properties box is...

Hello I am having a issue trying to create a formula that when a checkbox is checked to copy the data from worksheet 1 to specific cells in worksheet 2. If the cell that is being copied over is blank then it should display blank on worksheet 2. If the checkbox is unchecked C5:C12,B5:B12,D6:D12...

Hey all, I'm trying to find a formula that will help me with a project I'm doing. Im creating a meeting attendance record and am using checkboxes to check the person in the meeting. At the bottom of the sheet if they are supposed to be in a total of 5 meetings this month and only come to 3. I...

Thanks for any help , it is needed, i have searched and tried to find some code to make my own but have no luck so i am looking to this forum yet again for help. So what i am looking to do is to simply copy values of a cell and paste the value in another cell on a separate work sheet using...

Hey, I bring another problem to you people. I have some VBA code to check the last row of a certain table and create a checkbox in that row, if there are none. Problem is, if a row is created in the midle of the table, no checkbox is created in this row, because it is only looking for the...

Hi guys. I have a table with a row for each employee of my company. In each row is created a checkbox in column B (with a macro that runs in every change made on that sheet). Is there any way that I can delete a checkbox if I delete a table row? It doesn't need to be the checkbox in that same...

Hello excel experts. I'm trying to create a checkbox in column B, linked to column C, for each new row that I create in a table. I have this VBA code that I'm testing and its a mix of recorded macro and code found on the internet: Sub ButtonClick10() Dim lastRow As Long Dim sh As...

Hi, I'm trying to enlarge checkboxes with vba. I have managed to do this but sadly I cannot hide the source cells that the checkboxes link to. If I do that the linked checkboxes disappear. Does anyone else have the answer please?

Hi I have asked number of experts on youtube but none of them replied I assumed they have no answer. When I apply filter to any column the Column that contains checkbox overlaps. Checkbox are in C Any solution to this issue ABCDEFGHIJ12To Do ListStatusCell Linked3Define your project...

Hi, I am really new to Excel and I am really over my skill set. But I really want to have a tasklist, with daily, weekly, monthly, quarterly and yearly tasks. I also have a checkbox on each row on the different sheets, since I have the dailies on the daily sheet and so on. Is it possible to...

(I apologize if this topic has already been addressed elsewhere) I am very new to VBA scripting, but I have managed to write the following: Private Sub Unused_02_Click() If Sheet1.Unused_02.Value = True Then Sheet1.Range("C18:C117") = "X" Else Sheet1.Range("C18:C117") = "" End If End Sub...

Hi, all I'm Creating a job board where I need a row moved from a "Working Jobs" spreadsheet to a "completed Jobs" spreadsheet once the checkbox for said row has been checked. Can I get some assistance with this? Thanks!