checkbox

Ok So I have checkboxes I use in If statements thorughout my workbook and after adding one final it seems no matter what I do it will not recognize the value I have declare the variable for the checkbox as normal Dim RnFinalCB As CheckBox: Set RnFinalCB =...

So I have a checkbox on the page that I want to hide and unhide a row, playing the script it works perfect but when I click the checkbox it only works once but wont uncheck and unhide. Im sure its simple but I'm missing it somewhere. I have the checkbox declared as a variable already when I...

I have a userform with checkboxes that push a yes or no into another sheet that drives the model. The problem is the code is bogging down and taking too long to refresh. Does anyone have an easier way to loop through all the checkboxes on the userform and push the yes / no into the cells? Below...

Hi! I am trying to figure out the best way to do this. I have two access queries. Person 1 and Person 2. There is a checkbox for Person 1 to send to Person 2. When Person 2 is done, they would select a checkbox showing complete and it would go back to person 1. I am unsure of how to get the...

Good afternoon, I am trying to create a macro that will insert a new row at the bottom of a table and add a checkbox to it. The goal is if a user needs to add 2 or 3 lines, they could run this macro 2 or 3 times. Thanks in advance!

Ok, So I have a lot going on in this workbook and just trying to clean up all the script etc in this workbook and wanted to know if it is possible to declare everything below ALONG WITH Setting everything so when I get to the codes I dont have to "Set" anything just use the code like...

Hello all, I'm not terribly experienced in macros, but I'm learning as I go. Any help is appreciated. I have a workbook with many worksheets inside it. From a master worksheet, I'd like my staff to be able to select which worksheets to print by selecting them with checkboxes. I have a macro...

Hi all, I have a load of checkboxes where once ticked (or unticked) put a "X" into a cell. Instead of: If Me.chkTempWarm.Value = True Then wsMain.Range("H25").Value = "X" ElseIf Me.chkTempWarm.Value = False Then wsMain.Range("H25").Value = "" End If If...

I need some help with some vba code for my spreadsheet. I have an excel table and I need a 1.1 to be entered in to column AB of a selected row upon the selection of a checkbox, and if the checkbox is unselected, I need it to go back to a 1. My table is tblCosting and the worksheet is called home.

Hey Guys, I'm trying to hide a text box and make it reappear using a checkbox. Once hidden or cut and pasted I need to then hide the rows where the text box once was. I have read online you can't hide and unhide a text box using VBA... so instead I have chosen to Cut the group of text boxes...

I have UserForm1 that adds a new row of data to ws1 based on the data submitted in the UserForm. In column "E" of this new row, I'm trying to get the UserForm1, CommandButton1 click macro to add a checkbox to the empty cell, center it within the cell, and then use the value of...

Hello I hope you all can help. Sheet1 contains an activeX control (checkbox) which once ticked, columns H:M in all sheets sheet2, sheet3, sheet4, sheet5 will hide themselves (and when unticked, reveal themselves) The VBA used (from another thread) is: Sub ShowHideColumns() 'Assuming...

I have added a checkbox in a cell. I want the character " ' " to be added to to another cell if I check the box. The other cell stays blank if the box is not checked...Thank you

Hi, I am looking for a help to create the checkbox. In the spreadheet column A1 to E1 has to be updated manually. Once the data is updated, i am looking to have a checkbox created in F column, if i tick the check box, first requirement is 1) cell A1 To E1 should get locked 2) in cell G1...

I have a spreadsheet and part of the code contains the following : Worksheets("home").Unprotect Password:="costings" If txtIncrease.Value = True Then If Worksheets("home").Range("E5").Value = "Activities" Then Worksheets("home").Range("X5").Value = "1"...

Is there VBA code to hide all rows that are a certain color if a checkbox is checked? Here is a screengrab of what I am working with - https://ibb.co/8Kqgpxw I want to be able to uncheck the checkbox next to "A" in B1 and have all of the yellow rows get hidden. I used a simple code to get...

Hi. I am not a VB programmer, but I expect the answer would be easy for those who are. I have a simple VB routine running on a spreadsheet that clears the contents of a cell when the value has been changes. I would like to add a checkbox to my spreadsheet to turn on or off this feature...

Hello again! And thanks for your time! Well, I found a very usefull code to add many checkboxes in the Sheet, but I was trying to do something more. I was trying to check if the cell has a checkbox already, if not, then it should add it. The code is the next...

Hi I made a custom tab on the ribbon. There is a way to get the status of the checkbox ? Can i acces the checkbox by it's name ?

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...