checkbox

I have inserted an excel table into my spreadsheet and I need to be able to update all rows of the table in column M with a 1 if a checkbox isn't selected and a 1.1 if it is selected. The table starts in column A and it is called npss_quote. The checkbox is called chkincrease. Can someone please...

Good Day, I have a worksheet that is essentially a checklist to be completed. For each section it contains line items and each line item has a checkbox for "Yes", "No", & N/A. I am no VBA expert by any means but would like to covert to a PDF document and maintain the checkbox functionality. I...

Hello, I have a document that has a couple of sheets. Sheet 1 has 3 rate plans 1. Basic 2. Standard 3. Platinum Each rate plan has the inclusions documented on another sheet in the same workbook. What I would like to know is it possible for a rate plan to be selected and the inclusions on...

Hi, I have a listbox that is populated based on usernames listed in cells A5-A24. Each username has a checkbox, if the checkbox is selected, I need to send an email with an attachment to that user. I have each of the associated emails listed in column F. The macro I have first creates and...

Hi, I have a userform that populates checkboxes dynamically based on a user list on one of my worsheets. I'd like to send an email to all of the users where the checkbox = true. How do I associate an email with each of the checkboxes? Further info: The user list is in column A and their...

I have the following code that creates a list of checkbox items on my userform based on cell values on a worksheet. How can I set each of these checkboxes to default as true? If possible, I'm also looking for a way to set the size of the userform based on the number of checkboxes created. For...

Hello, I currently have this formula and need it to pass a value "X" into the Cell if it's checked within the Userform Checkbox. There are 50 checkboxes and I'd like it to pass "X" into the selected one. I currently get "False" inserted into the cell. Private Sub CommandButton1_Click() Dim ws...

PURPOSE: If a specfic checkbox on a userform is checked, then it needs to look in a specific cell for a specific string on a worksheet and if found, then that row is to remain visible, and if not then then that row is to be hidden. MY PROBLEM: The range that it is to be searching in has already...

Hey guys ive search this forum and found how to lock and also how to link; a checkbox to a cell but when I sort my data the checkbox remains where it was placed. My spread sheet is an inspection list where cell A1 is true/false Cell B1 is my checkbox (Active X) Cell C1 is an address...

I have a userform with a multipage, and on each multipage I want to add a command button which opens another userform with a textbox to add notes. So far I have the notes linked to a cell on a hidden page, say "K5", and when there are notes on the page I want a checkbox to be enabled so the user...

Hi newbie question please. I'm trying to create vba for checkbox when checkbox = true, display date/time else display blank/null Thanks in advance:)

Hi goodafternoon, I have thecode below where I am trying to add another line after the Comments which iswith a checkbox. I want to add ‘ Job Type’ as a heading and the ComboBox6 Data if the Checkbox1 isclicked, can you help please? [HTML] Private SubCommandButton2_Click() If...

Hi hope you can help, I have the code below for when the check box is clicked it sends an email, but I have just added the uncheck checkbox code, and this now sends 2 emails instead of the 1, 1 for when its checked and an email for when unchecked, can you help please? Private Sub...

Hi I can anyone help please i have 2 worksheet, worksheet 1 has all patients names in column A2 - A22 and address in B2 -B22. In column C I have a checkbox alongside each name/address. What I want to do is tick the checkbox and the name and address of the person on that row will move to...

Hi, I am trying to get my excel spreadsheet to highlight rows containing the word ‘June’ in column C1 when I have ticked my checkbox. I have my checkbox linked to cell N11 via conditional formatting so my formula at the moment is AND($C1=‘June’,$N$11) However, this is returning (when my...

Hi all, I have added a checkbox, CheckBox1, to a sheet. When checked, I am trying to send the values of E29 and D29 to the first empty row, to columns A and C on a sheet called Sample. Any help would be greatly appreciated. Thanks, Chris

Hi, I am looking to insert a new checkbox into the next empty cell. I can get this far, but then can't specify the properties of the box. See below: ActiveSheet.OLEObjects.Add "Forms.CheckBox.1", Left:=1206, Top:=(Range("T" & Rows.Count).End(xlUp).Offset(1).Top) + 2.25, Width:=12, Height:=12...

Hi, I need help. When I check a checkbox I want the text in listview to be highlighted in blue, I am having a problem where whenever I do check the checkbox the text does not highlight blue unless I move my cursor into the listview. Also whenever I check each individual checkbox in the listview...

I have a Userform which is populated from a worksheet using a Combobox selection, or data is added to the userform and then added to the worksheet. Within the Userform I have a Checkbox that indicates if a certain piece of paperwork is present for that specific Project. If this Checkbox is true...

Hi guys, here is some code but I suppose there would be a better way to do it? What I'm doing is, on button press check to see if a checkbox is checked on the userform and if so call a routine that looks in column A and hides the row. For example, if checkbox A is checked then call routine...