Hi Donna,

Sounds like it might be an idea to dispense with your dialog and write one
set of code for your checkboxes in a "WithEvents" Class module. Not sure if
you need Checkboxes on a worksheet or on a userform, but can use this
approach for either. Plenty of examples in this ng.

Regards,
Peter T

wrote in message
oups.com...
Good Morning Chaps and Chapesses,
I have never used Dialog boxes before, I usuually use UserForms.
Are they more temperamental than userforms? This morning i have used
the code from j-walk.com to generate a dialog box on the fly but ever
since then I randomly get the blue screen of death that automatically
reboots your machine for you (isn't it thoughtful!). It doesn't always
happen when the macro is run but happens at a later date when using any
program.

I am using a dialog box to avoid writing too many event procedures
unless anybody can tell be a nifty way of doing it.

I have a varing number of checkboxes named CheckBox1, CheckBox2....etc
If the checkbox is ticked I want a 1 in an array or a 0 if not ticked.
Can I write an event attached to the OK button that will loop through
all CheckBoxes and the condition of them and assign a value into an
array? If so, can somebody give me a bit of sample code as I still get
a little confused when writing action codes.
Thank you all.
Donna