activex checkbox

Hello - I am using activex checkboxes to hide/unhide cells as well as sheets. I originally wrote the code to update the sheet name based on cell value, but then the check box code would fail. Now I am trying to write the code to continue working no matter what the sheet name is changed to...

Hi Enthusiasts, I have one excel cell with 25 ActiveX check boxes. I have manually associated each checkbox in row 3 with a cell (i.e. the Microsoft Word checkbox in row 3 is associated with CF3, the Microsoft Excel checkbox is associated with CG3 etc). I have dozens of rows of Official Record...

Hi there, How do I change the background colour on my activeX checkbox? The RGB colour is 226, 242, 246 but how do I convert that into a code that resembles this: &H80000018& Thank you!

Hello, I am trying to hide/unhide rows and activex checkboxes based off of the value of an existing activex checkbox. I am trying to: - Unhide Rows(18:19,22) when the "Yes" checkbox of row 17 is True. - Unhide Rows(20:21) when the "Yes" checkbox of row 19 is True. - Unhide Rows(23:24) when...

I have =CUBEVALUE() functions referencing twenty Lists created with Data Validation (Bolded below). =CUBEVALUE("ThisWorkbookDataModel",$B$2,$B$3,$B$4,$B$5,$B$6,$B$7,$E$2,$E$3,$E$4,$E$5,$H$2,$H$3,$H$4,$K$2,$K$3,$K$4,$K$5,$N$2,$N$3,$H$7,$A$1,$A12,B$11) The limitation is that only one value per...

Hi, I am looking for update on the below VBA code so that it also adds up a small green tick-mark in the cell & it changes color to red if the value of the cell changes. Thank you for any help on this. I am an accountant & tracking changes which have been already finalized is a big nightmare...

hi, i need help with this I have a checkbox "aa" when check, it will display in cell F5 then value in B2 But when i change B2 without unchecking "aa" Cell F5 still shows the old value. Im using checkbox activeX. Can it be done as when i change a new value into B2, F5 will auto update without...

Hi Hope you can help is there a way to 'select' the adjacent cell for an activex checkbox, without referring to the cell by name. the following code selects the correct cell, but I have to name change the code for every checkbox and I have dozens of them :eeek: This is part of a bigger picture...

I have just spent days creating a long checklist document using form controls. I have now realised that I need to be able to filter the list and move and re-size the checklists with the underlying cells. Research on these boards suggests that I should be using Activex controls to achieve that...

Hello. I am new to vba scripting and any help would be greatly appreciated. I have a spreadsheet that has multiple sheets. The "User Access Form" sheet has several activex checkboxes. I would like to copy the fields that are checked to the "Info" sheet, which is currently blank. :confused:

Hi. I am working with several spreadsheets that track audit results. I am trying to take the items in cells a3-a6 from the workbook "action item" sheet "tracking sheet" and post it to another workbook called "oss kpi" sheet "February" in cell "a65" That is part one. Part two: is there a way to...

Hi, I created a questionnaire on excel, with Activex check boxes. the checkboxes unhide the rows of the next question, depending on which one you answer. So I have hidden the checkboxes in the same rows as the question, using the 'move and size with cells' option. I set it up and it worked...

I have a table it has over 400 rows and 13 colums. Data contains history of equipment being rented to customers. Columns includes Id No., Client name, Clients address, Equipment, equipment type, date rented, date returned, delivery location, invoice no, remarks etc . There is search box, its...

Hello, New to MrExcel. I know my problem is posted in other threads, but I can't seem to find any solution. I have Excel 2007, and I have a workbook with ActiveX checkboxes on the worksheet. I also have a macro that ties the worksheet to see which checkboxes are ticked or not. I was using...

I'm looking to create a VBA to filter the entries in a column (either strings or numbers) based on the input in a text box. Currently I was looking at using the ActiveX TextBox to hold the input. Ideally the function would search for partial matches as well as exact. An example would be that...

Hi all. I am new to this forum and try to programm an active checkboxlist. trying for several days now and i get stuck on getting the VBA working. I have a list in excel with activex checkboxes in every row. I want to see that when the checkbox(es) of certain row(s) is checked, that then the...

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

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 am using the code below unsucessfully: ActiveSheet.Shapes.Range("Function").Visible = msoFalse ActiveSheet.Shapes.Range("Function").Visible = msoTrue The worksheet contains 10 activeX check boxes that I have assigned all the same GroupName "Function" Basically, If Target.Value = "Hub"...