checkbox

I have written the below code in excel vba to log changes made in sheets to the change log sheet. I want to disable that sub if a check box is checked. This code works perfectly for what I need it to do, just need to figure out a sub that does not allow this to run if a box is checked so every...

Hi Folks, I am starting with an example found here to dynamically create checkboxes on a user form - with a Class Module for events. The example shows the value of each checkbox in a message box when it is clicked on the form. I am trying to loop through the entire collection of checkboxes...

Hi Folks, I have a table with upwards of 1000 entries on it and multiple people will be working off this file (not at once). The idea is simple, you check a check box and it adds a time stamp into the "Sent Date" column. Each box is linked to the neighboring cell. However using the NOW() or...

Dear Excel-Pro Community, I need Your help. I am looking for a solution, where I can do the following: I have a table, where I want to build a SUMPRODUCT formula, with multiple conditions. I am already OK with the conditions, but in the table I do have a column (Named: Weighting), where I have...

I have a UserForm that has three CheckBoxes and some ComboBoxes. The plan is that these CheckBoxes can be clicked on or off by the user, and that will trigger a filter in a Worksheet immediately (without having to close the UserForm), so I use the Click event for the CheckBoxes. The UserForm...

Hello, I am trying to make this code work: Private Sub commandB_Click() If Cells(ActiveCell.Row, "G") = "Výtah" Then realita.vytah.Value = True End If If Cells(ActiveCell.Row, "G") = "Konstrukce" Then realita.konstrukce.Value = True End...

Hi guys! I created a user form with various checkboxes. I need a code that will write all the selected checkboxes into one cell divided with comas. For example: If a user checks the boxes "apple" and "pear" I want to write apple, pear to one cell. If the check only "apple" it should write apple...

Hi All, Can someone please help me to hide/ unhide rows on another sheet based on Text Value? For example, if 'Purchase Order' is enabled using a checkbox or a button, then rows containing 'Purchase Order' in a specific column, in this case Column D, will be shown. Note: I am trying to make...

Hi all, I'll be the first to admit I'm quite new to VBA, but delving into it as much as I can. I've been building a questionnaire & want to be able to hide certain rows based on a certain value of a cell. I have managed this successfully on one sheet within my workbook, however when I copy...

Hi everyone! I have a sub that I want to use on various checkboxes on various sheets. So I set the checkbox as a variable called Cbx: Here's what I've got: Sub Checkbox(Copysheet As Worksheet, ButtonSheet As Worksheet, Cbx As Checkbox) Application.ScreenUpdating = False If...

Is it possible to change a checkbox, if checked, to an asterisk only during printing in excel? But if the checkbox is not checked then it would print normally as an empty checkbox.

Hi All, I've done some searching but could not find an answer for this. In my userform there are a couple of textboxes, a combobox, 12 checkboxes and a listbox populated with a table. I would like all of the boxes to populate when I select a line in the listbox. Using the click event, I can...

Hello all, I have a spreadsheet with some checkboxes and text boxes. I would like to write a macro so that when I check a specific checkbox, it automatically enters into a specific textbox. I've found properties such as "enter", "setfocus" but those only seem to apply to form textboxes, I...

Hi All again! I am stuck again in a pickle and I have no idea how to get out of it. I am a newbie and this forum has been a life savior. I want the orange table to add a new column and fill it with check boxes each time a new member is added in Blue table. and If a new row is added in the...

Hello all. I have Sheet1 where I want to put data on cells B2:E20. I want to place a Conditional Formatting on these cells. Basically, I want to fill the cell if a data is entered - doesnt matter what data, I will put something in that cell. However, the fill color on the cell will be dependent...

Please help if you can. The code below is to insert a new line at a row referenced from "uc" then copy the checkbox from a previous row and assigning the correct linked cell for the checkbox. It works upto the line where the linked cell is assigned (row inserted and checkbox created) , the...

Hi all, I've always found my answers to excel questions on mrexcel, however, at the moment I'm struggling! I'm not that experienced with Excel. I have made a checklist with Check Boxes (Form Control), which is linked to the column beside it. When checked, TRUE appears in the column beside...

hi all, The following code showing my userform contains approx. 170 checkboxes. Sub macro1() Dim ctl As Control Dim j As Long 'Dim msg As String j = 3 For Each ctl In UserForm1.Controls If TypeOf ctl Is MSForms.CheckBox Then If UserForm1.Controls(ctl.Name).Value = False Then Cells(j, 5).Value...

Hi, I have a list of 20 names in column B. Everyday I need to select 6-8 of these names and have them appear in col J without skipping cells, without duplicates and without using a formula in J. If cells get skipped it will break the formula on another sheet that is the purpose of the workbook...

I have 50 checkboxes in 5 sets of ten, I was looking to implement a check all function to be able to check each set of ten if needs be, so 5 new boxes each with the ability to check all in their category. I have looked in a few places and can only seem to find check all on sheet (below) or...