Hi George,
You need a Class Module.
Have a look at this example at John Walkenbach's site;
http://j-walk.com/ss/excel/tips/tip49.htm

It implements a colour picker dialog box. Basically, when you hit any
of 56 different buttons it runs the same macro. You should be able to
adapt the code for your requirements without too much difficulty, and
it's quite enjoyable getting it to work!
If you can get it, have a look at Excel 2000 VBA (2002 by now??) by
John Green et al, Chapter 13 on Class Modules too.

regards
Paul


"George J" wrote in message ...
I am trying to fix a questionairre that has about 60
checkboxes. When any of the checkboxes are clicked, to on
or off, I want a particular macro to run.

I have tried using the worksheet change with the target
being the linked cells that the user has for each
checkbox, but this does not kick in.

Can anyone suggest anything?

thanks
George