Home |
Search |
Today's Posts |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clearing Check Boxes & Running a diff Macro when unchecking the ch
If you think that a combobox would be easier, you may find that Data|Validation
is even easier. It looks kind of the same and behaves kind of the same, but is lots easier to implement (and lots easier to break!). Debra Dalgleish has lots of tips: http://contextures.com/xlDataVal01.html Vick wrote: I was looking at it and a combo box might be easier, but I have no idea how it works. How do I get my values in the drop down box? Also, can I have a macro run for each of the selections in the drop down box? I'm open to new ideas, whatever is easiest is fine with me. Thanks Again "Vick" wrote: Ok, I'm using the Control check boxes. I have 6 of them. On each of the 6 I have assigned a Macro to do something on the page. I have 2 problems. 1)I want to make so that only one box can be selected (Not sure if there is a way to do that or have a macro to clear the rest of the check boxes) 2) I want two different actions when the box is unchecked. Right now the macro runs when I check or uncheck the box. I would like one macro to run when I check the box and one to run when I uncheck the box. Is there a way to accomplish this? Thanks -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unchecking check boxes on exit | Excel Discussion (Misc queries) | |||
Clearing List Boxes | Excel Discussion (Misc queries) | |||
Clearing Check Boxes and Cells | Excel Discussion (Misc queries) | |||
Clearing Check Boxes and Cells | Excel Discussion (Misc queries) | |||
Clearing Check Boxes and Cells | Excel Worksheet Functions |