checkbox

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

I Team, I need help with code for an excel macro, which sends users to another sheet in an excel table once a checkbox is checked, but does nothing if it is unchecked. I tried this already, but no luck: <code>Sub CheckBox28_Click() If OptionButton1 = True Then...

Hi, I have a code that works for one checkbox to update the textbox(txtTotalBulk)... But I'm clueless on how to add up the rest of the checkboxes... Code goes Private Sub bulk1_Click() Dim i As Integer i = 1 If bulk1.Value = True Then txtTotalBulk.Value = i Else: End If If...

I know I've seen it here, but cannot find it, so apologies for a potentially duplicate thread: Checkbox added, when "checked", I need a field (AG70) to display specific text/value ("Incld"). How? Thank you!

Hi I have a excel sheet with 50 rows and 17 columns. I have 1 button in the top of the sheet and I have one checkbox in column A of each row. I need a VBA code that can do the following: When a checkbox is checked and the button in the top of the sheet is pressed, then excel should copy the...