checkboxes

Hello, I have an excel sheet that has multiple line items that a user needs to check a "Required" checkbox or a "N/A" checkbox. If the "Required" checkbox is selected, then the user either needs to select a "Completed" checkbox OR fill in a comment in a cell to explain why it is not yet...

Hello, I have an excel sheet that has multiple line items that a user needs to check a "Required" checkbox or a "N/A" checkbox. If the "Required" checkbox is selected, then the user either needs to select a "Completed" checkbox OR fill in a comment in a cell to explain why it is not yet...

I have put together the following VBA to delete rows on a worksheet (there's another VBA for adding rows, not shown here). I want to be able to delete the row contents, together with the associated checkboxes in that row, and move all rows up to fill the space. For info, G4 = value of row to be...

Is there a way I can loop through all Checkboxes in a Frame on a Userform? All of them are named individually, so not CheckBox1, 2 etc if that makes a difference.

Hi Everyone, I have a set of checkboxes there names are CheckBox21 to 30 I just need a macro that if none of the boxes are checked I get a messagebox saying "please select one" how can I do this? Thanks Tony

Hello... Can someone please help. I have a frame within a user form that contains 6 checkboxes. The user may select more than one checkbox. I am trying to send the caption of the selected checkbox(es) to the body of an email. I wrote the code below but it returned the same one twice (see the...

Hi, I have word document Evaluation Form. My goal is to create a more automated Evaluation Form into Excel that includes formulas. The Evaluation Form has a scale in each area from 0 to 4 (increments by 0.5 beginning from the rating 2). I am fairly new to excel and need help for this project...

In cell E2 I've inserted a checkbox. Then I applied a Format Control to it so that TRUE/FALSE will appear next to it in F2. Now I want to replicate that checkbox down the column with each checkbox displaying TRUE or FALSE to the right of it. I can replicate the checkboxes but checkmarking one...

Hi Friends, I have some data in first column of my excel sheet.I want to display that data to user through checkboxes and then let user check the required data . After that I want to paste the selected data in the column adjacent to it. I am unable to loop through checkboxes because everything...

Good afternoon Excel gods I have an issue with an excel spreadsheet...which I did not create. There are 5 check boxes [on the joining tab]. When a check box is selected it increases/decreases the columns that are in a table by 1 based on the number of crew that are currently onboard the vessel...

Hello everyone, I am working on an excel medical questionnaire using form checkboxes on a worksheet, the questionnaire is devided into several categories, each categorie uses a macro like the following to select a certain option for all items in a given categorie: Sub...

I have created a list box and added checkboxes. I would like to have an output say "Checklist Completed" once all the checkboxes have been selected. I'm new to VBA and don't know where to start. Thanks!

Hi There, I'm putting together a performance appraisal form with checkboxes. Picture tasks down the vertical, and checkboxes across the horizontal in a chart format. There are 7 rows (tasks), and 5 columns (rating points from 1-5). My grid looks like 35 checkboxes, with only one possible...

Hello, If anyone can help me with this matter I will be very grateful. What I have is a list of columns with checkboxes and I want at the bottom of each column to be a total ! Thank you! here is a picture of the file https://ibb.co/d2Hh7m

I have been trying to find a method using VBA that would allow me to have a generic code to use. I have about 20 sheets and each sheet has from 2 to 20 checkboxes (form not activex). How can I make the code without having to do each and everyone individually?

Hi I have a code to select/deselect all checkboxes with one "master" checkbox. This code is for OLEObjects/Active X controls, and im having a hard time rewriting it to work with Form Controls checkboxes. Any idea? Private Sub CheckBox1_Click() Dim i As Integer For i = 2 To 39...

Hello All, I have a userform with 3 checkboxes. When userform initializes only one checkbox (checkbox1) is enabled and rest two are disabled. I want when user check(select) the checkbox1 then only other two checkboxes get enabled and when user check again (deselect) the checkbox1 then other two...

Hi everyone, First time poster here! I found this site to be an amazing resource to help me achieve the first step of my Excel file, but now I have hit a wall as I can't find an answer for what I am looking to do (probably my poor searching/lack of Excel skill!). Background: I’m making a three...

I have a class module set to encompass ALL checkboxes on sheet, so that when any of them are clicked, a sub will run to populate some cells. It works great, but I'm having some trouble because I still want to group some of the cells together to create a user form. I'll have tons of checkboxes...

I have a Userform having several Checkboxes and a Button to perform action. I want to loop through all checkboxes, If the value of check box is true it should show its Caption in MsgBox. but my code return error. Dim C As MSForms.Control For Each C In Me.Controls '<--| loop through...