check box

  1. J

    Google Sheet - Count Drop Downs, Total Columns, Check, Array - Errors

    Can someone please fix this Google Sheet for me? I need it desperately for work. I cannot figure out what I'm doing wrong, and every formula I've looked up doesn't work for me. It's driving me CRAZY! o_O I've highlighted the columns that are giving me issues in yellow (sheet linked at bottom of...
  2. K

    VBA for using a check box to Regen that row and then uncheck the box (ready to run macro again)

    Hello All, I'm making myself a task list, in this list i will have repeating tasks. Once the task is done (and dated) it needs to be done again (think how the laundry is in an never ending loop of despair). I'm VERY new to VBA and despite a few days of google searching (which I, previous to...
  3. A

    Multiple userform checkbox values

    I am trying to take the values passed from a userform that has the following checkbox options and write them to a single concatenated cell. Thank you for your help. Any suggestions would be greatly appreciated. I currently have attempted this, but can only get one option to show up at a time...
  4. madkinson

    Use Check Box Value to Auto Fill Table

    We have an idea that should reduce keying errors when a user enters a bill of lading in our ticketing system. I've developed a simple Excel sheet with a list of all available rail cars. The can use a "Select All" button to select all cars then uncheck the ones that aren't being used for this...
  5. S

    Multiple Linked checkboxes in a single cell

    I would like to have 3 linked checkboxes in a single cell. All 3 need to be linked to their own seperate cell. I can do this manually but I need it going 3 columns across and 500 rows down so was wondering is there some vba code I could use to carry out the exercise? TIA
  6. B

    Multi-Selection on UserForm

    Hi All currently working on a UserForm where people can request new accounts for their team members. i was thinking of using check boxes or option buttons for 3 of the options to say what systems the user needs access to(BLS/ANA production environment and BLS/ANA Test environment) users don't...
  7. R

    Grocery List Generator from Recipe List - Google Sheets

    Hi all, Wondering if you can help, although I may have bitten off more than I can chew with this haha. Basically I am creating a grocery list generator (or attempting to) where on one sheet is a list of recipes and their ingredients and optional extra ingredients, with check boxes (see image)...
  8. M

    Hide/Unhide rows based on value with a checkbox

    Hi everyone I hope, that some of you are able to help me. I have a large excel sheet with a lot of rows. I column "F" I have the status stated. It can be open, closed or blank. I would like to have a checkbox that hides every row with the status of "Closed". I have tried this, but that won't...
  9. T

    Hide/Unhide rows based on 2 checkboxes

    Hello, I am trying to hide/unhide certain rows based on checkbox. I am using Form Control checkboxes. I am using the following VBA code for single checkboxes: Sub CheckBox17_Click() If ThisWorkbook.Sheets(1).CheckBoxes("Check Box 17").Value = 1 Then...
  10. AJWildOne

    Check Box True return Today's date

    I added a check box in Excel that returns "TRUE", "FALSE" in cell D38 Then added this formula =IF(D38="TRUE",TODAY()) to D34 where I want today's day to display if the checkbox is "True". Seems simple and would be very usefull but it doesn't work. Any suggestions for syntax?
  11. B

    Sum calculation using a checkbox

    I’m creating an estimate form and I’d like to be able to calculate a sum whether a box is checked using the checkbox in a cell?
  12. S

    Copy worksheet from template

    Hello, I have played with this and still can't figure it out. I have connected this macro to a check box: Sub copy_Sheet() Dim wb As Workbook Dim activeWB As Workbook Dim FilePath As String Application.ScreenUpdating = False Application.DisplayAlerts = False...
  13. G

    Add checkboxes to Listbox

    I have many checkboxes that I would like to move to a listbox to make things look neater in my spreadsheet. I have never used the listbox but I would like it to include all of my checkboxes with the option to choose multiple checkboxes. I know I must change the properties of the listbox...
  14. tlc53

    VBA Save PDF file of each sheet from Dashboard

    Hi, In my Dashboard sheet I have totals that feed through from each of the client sheets. Next to these totals, in column G, I have check boxes. I would like a saving macro to run if the check box is ticked. So; Sheet1 (Dashboard) Check box ticked - save pdf file of Sheet4 (Cordis) Check box...
  15. tlc53

    Hide Check Box with VBA Code

    Hi there, Trying to get this code to work but not having much luck. It currently does nothing. Can anyone see where I am going wrong please? Thank you! Private Sub Worksheet_Change(ByVal Target As Range) If Target = Range("d8") = 1 Then...
  16. reneev

    Macro/VBA Questions:

    1) Uncheck boxes with Macro Button - I have created a form in Excel which when protected, users can tab through and fill out either by typing, drop down boxes or checking a box. I created a macro button to "Clear Form" but the only thing it won't clear are the check boxes even though I've...
  17. I

    Selection of dropdown list value with a checkbox

    I need help trying to implement a check box to automatically select a dropdown list value when checked, but when it is unchecked i would like to be able to select the value from the dropdown list. So, I have: <tbody> A B C left right left right left right upper ? ? ? ? ? ? lower ...
  18. V

    Make a checkbox add a specific text in another cell

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

    User Form ComboBoxes and CheckBoxes are blank

    Hi All you Guru's! I am having a little trouble with my use form. The form has 5 combo boxes and 12 check boxes. All my links work and everything seems fine with the exception of when I open the user form all the boxes are blank. So If I select 5 check boxes and then close it and then reopen...
  20. B

    VBA, Date changes when box is checked

    Hi, I have been working with an Excel file to send automatic mail based on some criteria and change dates when the ActiveX check box is checked. Condition: If I check the box, 'TRUE' is displayed in the adjacent cell. If TRUE, the current date has to be added with numbers (7, 30, 120...

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