check box

Hi Forums, I have just completed a long and tiresome VBA code and was excited to send the report out to my boss. However, when testing the file on a coworkers computer, I found that none of my active x controls are working! On my coworkers computer (have tried with multiple coworkers)...

Hi All, I have the following running on inserted check boxes, which I'm mostly happy with. The issue I have is the values paste to sheet 2 and override the previous values. I need the values to paste in the next free empty row on sheet2, there may be others rows in sheet2 with values that need...

Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim c As Range If Target.Cells.Count > 1 Then Exit Sub Set c = Intersect(Range("C14:C28"), Target) If c Is Nothing Then Exit Sub Cells(Target.Row, 1).Resize(, 5) = "" Target = "X" End Sub I had seen this on a previous post in...

I need a VBA code that will when used with a Form Control "Check Box" will unhide / hide a row. To be more exact, I'm needind the code to "Hide" row 34 when unchecked and "Unhide" the same row when checked. Can someone help me please. By the way, I'm using Excel 2010. Thank you!!!

hi all, i'm facing this issue i have activex control checkbox which is check automatically with private sub if some conditions are met but if there are no conditions I'm not able to manually check checkbox, because private sub keeps looking at the condition and keeps unchecking it. is it...

I'm not 100% sure if this is possible but, what I'm trying to do is have one sheet, read the value of a cell that will correspond with the name of the check box in a different workbook and tick that check box. So far my code is Private Sub CreateTicks_Click() Dim f As String Dim ff As String...

Hi, I have a set of Form Control check boxes on my Excel sheet which I have assigned to macros. However, for each row, I had had to create individual macros per row. Instead, I would like to just have the two macros below and use the format control cell link row number to set the checkRow...

Is it possible to group a set of ActiveX Check boxes and then name that group (All of the check boxes have their own set name) Original Issue I'd been having issues with ActiveX check boxes not moving correctly when the cell they are over are hidden (They were set to shape and size with cells)...

I have looked almost everywhere to find a macros for my active x check box and can't find one that I need. Your help would be awesome. I have a spread sheet that lists all the vendors. In row 5-154, Column V I have a list that states true or false. True = we will buy from this vendor...

Hi, I'm having some difficulties with some code that I cant quite piece together. I have a Userform which allows a user select a desired parameter from a listbox. Depending on the user's selection a set of checkboxes are created in a neighbouring frame. The checkboxes are iterated and produced...

Hello everybody, this is the first time for me to post a question here and I hope that you can understand the problem that I'm currently facing :) Furthermore, I'm a total VBA noob (really, I just started a few days ago) and also don't have any programming experience at all. Ok, here I go...

I currently don’t have any experience with using the check box function so I am looking for so I'm biting the bullet and asking for some help! I have 3 check boxes in G5 one of which is call "N/A". What I would like to do is: If the "N/A box" is checked then cells C5, D5 and E5 will auto fill...

I'm working on creating a customizable form for our office and need some help. The document I'm looking to create may have one component or multiple components depending on the needs of the individual person using it. In essence, one person may just need Section A to show, while someone else...

Hi folks, I'm new to the message board and had a question (of course). I'm looking to use Excel to validate an inventory. I have two columns of data, 'Asset Tags' and 'Serial'. I want to have Excel conditionally format a cell in a third column 'Validate' if it appears in 'Assets' or 'Serial'...

I am in desperate need of some help with some form controls. I need a way to manipulate a group of check box forms and/or combo box forms with a macro assigned to a single form control. For example, clicking a single "check box A" would check off all the boxes in an associated group. Is this...

Hello! I'm not great with VBA, and most things I've learned through other posts :). Basically, I am trying to create a table on a new sheet based on check box selections from another sheet. There are lots of selection options. First there's a list of topics that I have used ActiveX check boxes...

Hi! Here's the scenario: I want to have multiple check-boxes on my user form (around 16 options) but I can only have 4 selected that will go into either column F,G,H or I. It doesnt matter which they go into, but it thats where they need to go. I am fairly new to vba and have no idea the code...

I'm updating my home budget on excel and want to count certain things at different times. For example, column C has all of the amounts of the bills to be paid that month and a total at the bottom, whereas column D has a check box that I tick when each one is paid. Can I link the two so that if I...

i made a drop down menu in excel, hence is there a way to make a drop down menu of sub folders with the check box next to it, and once the option is being selected to show only the ones being selected? For example: I have a Solution option to choose from where I have options of Eastern...

I have a questionnaire that has a few hundred checkboxes (not ActiveX checkboxes) that users complete as a part of our quality control process. Depending on the nature of the job different boxes need to be available, so each checkbox has been named according to when it is to be displayed. An...