Hi Harriett,

What I would do is hide the checkboxes instead of
generating them. Pre-define everything (checkbox events,
properties, codes, etc) and hide them. Show them during
runtime by setting their properties to visible.

Hope this helps...

Chong Moua

-----Original Message-----
Hi everyone,

I'm trying to code a form in Excel using VBA. The form
needs to generate checkboxes at the runtime. I need to
modify the checkboxes' clicked event to call another
event in the form.

What is the best way to do this?

Thank you very much for your help.

.