Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I put several check boxes on a chart and assigned different macro to each of
them. All each macro is doing is hide-unhide a specific column. Say I have ckeck boxes "Weight", "Length" and "Width". Assigned macro A, B and C accordingly. When I click "Weight" checkbox it calls macro "A" which toggles "hidden" status for column "J". So all macro have same functionality, only for different columns. I would like to build a _single_ macro, capable to know which control box was clicked. So, all check boxes will be assigned the same macro and that macro should be able to receive check box name as a parameter and then use a CASE statement (or several IFs) to process appropriate columns. Is it possible and, if yes, how? Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Check boxes, Is this possible? | Excel Discussion (Misc queries) | |||
Clearing Check Boxes & Running a diff Macro when unchecking the ch | Excel Discussion (Misc queries) | |||
How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) |