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?

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?

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?