1. L

    How can I disable the change log sub that I have written by checking a check box?

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

    VBA Macro to Loop though CheckBox Values

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

    Time/Date Stamp based on Boolean Value, Formula only.

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

    SUMPRODUCT condition of an array

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

    CheckBox in UserForm not working

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

    VBA String in cell to check box value

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

    VBA checkboxes in user form to cell with commas

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

    Hide/ Unhide Rows based on Text Value - Checkbox

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

    VBA Cell Value to hide rows- works on one sheet but not another?

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

    Checkbox as variable not defined vba

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

    How to change a checkbox if checked to an asterisk when printing in excel?

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

    Tick checkbox depending on Listbox selection

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

    Enter into ActiveX Textbox with VBA

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

    Add new rows to table based on another table value

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

    Conditional Formatting based on Checkbox

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

    VBA to assign linked cell

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

    Excel Checkbox - How do i duplicate entire row when checkbox is ticked?

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

    Find missing checkboxes in userform

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

    Can’t skip cells, no dupes, no formulas

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

    Tick all in a selection of checboxes

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back