check box

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

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

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

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

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

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

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

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

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

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?

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?

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

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

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

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

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

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

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

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