Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check boxes and VBA code
I am creating a spreadsheet with multiple check boxes on it. There is
different code attached to each box, but when I click any box the code is being ignored and only the first set of code is being run. How can I fix this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
check boxes and VBA code
Do you have them all linked to the same cell. Are these from the control
toolbox toolbar or from the forms toolbar. (these are checkboxes and not optionbuttons? ). How did you attach the code? for Forms checkboxes: Did you rename it after you attached it? or for control toolbox toolbar checkboxes: Is this a copied sheet in xl97? Perhaps some sample code from two or three of them. -- Regards, Tom Ogilvy "Paul" wrote in message ... I am creating a spreadsheet with multiple check boxes on it. There is different code attached to each box, but when I click any box the code is being ignored and only the first set of code is being run. How can I fix this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
check boxes and VBA code
I have figured out what I was doing wrong. I had some incorrect code. Thnak
You "Tom Ogilvy" wrote: Do you have them all linked to the same cell. Are these from the control toolbox toolbar or from the forms toolbar. (these are checkboxes and not optionbuttons? ). How did you attach the code? for Forms checkboxes: Did you rename it after you attached it? or for control toolbox toolbar checkboxes: Is this a copied sheet in xl97? Perhaps some sample code from two or three of them. -- Regards, Tom Ogilvy "Paul" wrote in message ... I am creating a spreadsheet with multiple check boxes on it. There is different code attached to each box, but when I click any box the code is being ignored and only the first set of code is being run. How can I fix this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code for the Check Boxes in a form | Excel Discussion (Misc queries) | |||
CODE FOR CHECK BOXES, AND EXCEL AS ATTACHMENT ! | Excel Programming | |||
Code for many check boxes | Excel Programming | |||
Code for Many check boxes | Excel Programming | |||
code to hide check boxes | Excel Programming |