checkbox activex

Hi, I'm trying to find a macro code to hide/unhide certain/selected cells only using the checkbox. For example, if I tick the checkbox, it will show cells "A4:D9" but when I unchecked it, the mentioned cells will be hidden. Attached is a sample of my query. The shaded parts are the ones...

I have over 100 activeX checkboxes on a sheet. Some of the checkboxes are already checked/unchecked so I want the macro to ignore those. I found a macro to change all checkboxes to false but I'd like to modify the code to only change the value to False if the Value field in the properties box is...

Hello all - I am in need of assistance. What I am trying to do is create a code where I click on a checkbox using an Active X Control Checkbox and it only displays information in that column. For example, if my spreadsheet has "GM", I click the check box and the only column that appears is "GM"...

Hey everyone, I searched for a solution on this but I didnt find anything that works for me. The Commandbutton for this is located in Sheet 1 and i want the VBA Code to delete every row that contains "1" in Sheet 3, If ActiveSheet.CheckBox1 = False Then 'This is where I need the Code to work

This is my first post so please bear with me. I've recently started using VBA mostly by searching for what I need and copying code that fits. I have a sheet that is fillable and uses checkboxes to select certain data. I have a macro that takes the range of data and creates the email with a...

I have the following code to insert checkboxes in my worksheet. I am trying to have them maintain the property of moving with the cells, but it doesn't seem to be applying the change because when I right click and go to the format control window / properties tab, it is always at don't move or...

I have an Excel-sheet, which contains 6 checkboxes and a few cells which requires user input. The checkboxes are Active-X objects and I want the checkboxes visiblity to depend on the values in specific cells. This means that I want each checkbox to be shown/hiden, dependant on the user input...

Hello All, Need help with my work. I have a userform that has multiple checkboxes and a label. What I am looking forward is: 1. I want to copy the label into the textbox when one of the checkbox is selected. If multiple selections, one label only for the entire selection. 2. I want to copy the...

I have a workbook with three worksheets. On the first worksheet the user is asked to identify the discipline that relates to their project using an Active X Checkbox. So, they might select "Electrical" and "Mechanical" but not "Architectural". Based on their selection, corresponding rows...

Hi there, I am making a userform. I have to checkboxes, checkbox1 and checkbox2. I want to make it such that user can only check one of them at tiime. And I also want to make it as mandatory question for the user such that he or she needs to tick one of the checkboxes! thanks for your help

Hello, I am making a form. I have a checkbox1 and checkbox2. I want to make it such that whenever checkbox1 is checked then everything already entered in textbox1, textbox2 and Listbox1 is automatically deleted. So I want to have the above controls blank when the checkbox 1 is checked Please...

Hello, im trying to figure out how to make this work. I got a table with informaton. with a checkbox on the side of the table. simply explained: When the checkbox on the row is true, copy table row "b3:p3" to a new table. but i want it to be activated by a commandbutton, so i can choose 5...

am using the active X checkbox I am trying - to put data on two cells on another sheet once the checkbox is checked - remove the contents I pasted on the sheet if unchecked - Paste information on the next row if content is full here is what I did and its not working :: private Sub...

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

Hello All, I have a an Active X Button that when clicked brings up a Userform with checkboxes for each sheet in my workbook. What I am trying to do is allow the user to select which sheets they want to generate into a PDF. Currently, regardless of what checkboxes are selected once the user...

I am working on an interactive report linked to an olap Cube. One of my slicers has 20+ products available to choose from. For ease of use I've created an option box that groups those 20+ products into six categories. I've coded a click event for each option box to filter the products tied to...

Hi! Im want to make a loop for the purpose of entering and counting votes, so that when one ActiveX CheckBox is clicked the checkboxes in the same row and column are disabled (as you have to prioritise among candidates and can online votes for each one time). I have 14 columns and 24 rows of...

Hi all, I've recently generated an excel table for my company, showing every kind of assessment we do (followed by an ActiveX checkbox). The initial aim was to select any boxes you want, and generate a price at the end. Easy.Private Sub CheckBox6_Click() temp = "23" temp2 = "H23" If...

Hi, I am using a piece of code (copied below) that I found on another forum site. This macro uses check boxes and and that are checked on sheet 1 at the click of a button will copy the row data and paste it onto sheet 2 However the issue that I am having is that I want to specify what cell in...

Hi, I am making a workbook for work. I'm using activeX checkbox to hide and unhide certain rows when a checkbox is activated. In the section of hidden rows I have another set of checkboxes. I got the code to hide and unhide them, but if I save the file with them hidden and reopen the file and...