checkbox

I Team, I need help with code for an excel macro, which sends users to another sheet in an excel table once a checkbox is checked, but does nothing if it is unchecked. I tried this already, but no luck: <code>Sub CheckBox28_Click() If OptionButton1 = True Then...

Hi, I have a code that works for one checkbox to update the textbox(txtTotalBulk)... But I'm clueless on how to add up the rest of the checkboxes... Code goes Private Sub bulk1_Click() Dim i As Integer i = 1 If bulk1.Value = True Then txtTotalBulk.Value = i Else: End If If...

I know I've seen it here, but cannot find it, so apologies for a potentially duplicate thread: Checkbox added, when "checked", I need a field (AG70) to display specific text/value ("Incld"). How? Thank you!

Hi I have a excel sheet with 50 rows and 17 columns. I have 1 button in the top of the sheet and I have one checkbox in column A of each row. I need a VBA code that can do the following: When a checkbox is checked and the button in the top of the sheet is pressed, then excel should copy the...

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