| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macros for checkboxes
Glad we got there!
"Min" wrote: Yes it does work - thank you. I didn't realise that you could 'call' a macro, I thought they always had to be assigned to something Thank you for all your help - you have been very patient! Regards Min "Toppers" wrote: If they already have macros assigned you need to add the code I supplied to check if all 6 are checked. Or call macro from your existing macros.Will this work? Sub Your_macro() Call macro1 .....Your code End Sub This is the problem of working "blind" as I obviously only have a partial picture of what you are doing. "Min" wrote: My apologies for being a bit dim - especially when you are being so helpful. How do I assign macro1 to all 6 checkboxes that already have their own macros assigned to them anyway? I tried grouping them with a group box and assigning macro1 to the group box, but that doesn't work very well. "Toppers" wrote: Macro1 to the checkboxes, Macro to the Option button. Sorry ...I didn't explain this. "Min" wrote: Sorry, I thought I understood this, but I can't seem to make it work. What do I assign the 2 macros to? "Toppers" wrote: If you check all 6 Checkboxes, the option button isset to TRUE and if you then uncheck one (or more) of the Check buttons, the Option button is set off. If Option button selected, all Checkboxes are selected. Is this OK? C1:H1 are link cells .for Checkboxes ... Sub Macro1() ' Check Checkboxes .... If Application.CountIf(Range("C1:H1"), "TRUE") = 6 Then Range("B1") = 1 Else Range("B1") = 0 End If End Sub B1 is link cell for Option button Sub Macro2() ' Check Option button .... If Range("B1") = 1 Then Range("C1:H1") = TRUE End If End Sub "Min" wrote: Yes, this works. Thank you. But... I have 6 checkboxes that hide or unhide different columns. I also have an option button to 'show all'. If the user selects all 6 checkboxes then I want the option button to be true, otherwise it remains false. Similarly, if the user selects the option button then I want all 6 checkboxes to be true. Is this possible? "Toppers" wrote: Link the Option Button to the same cell as the Checkbox .. no other macro required. The Checkbox will set the state of the Option button. HTH "Min" wrote: Can I also add into the macro something that will make an option button true when the checkbox is true, and vice versa? "Toppers" wrote: I placed a checkbox from the FORMS toobar on a worksheet with C1 as a linked cell: this shows TRUE/FALSE. It called the following macro in a general module which hid/unhid columns OK. Sub Macro1() Columns("C:F").EntireColumn.Hidden = Range("C1") End Sub Does this help? "Min" wrote: I'm stilll really struggling with my checkboxes! How do I write a macro that will show columns on a worksheet when the box is selected, and hide the columns again when it is deselected? Many thanks to Dave who has already tried to help, but I need simple instructions! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checkboxes | Excel Worksheet Functions | |||
| Checkboxes | Excel Discussion (Misc queries) | |||
| Checkboxes and macros | Excel Discussion (Misc queries) | |||
| Checkboxes | Excel Discussion (Misc queries) | |||
| Checkboxes | Excel Discussion (Misc queries) | |||
Hybrid Mode
