Problem with creating a checkbox on the fly is that you also have to
generate some code to process them on the fly.

Far better IMO to add the max number of checkboxes you will need and hide
them, unhiding as required, or to use another method, such as dropping the
sheet names in a listbox or a combobox, and process the selected sheet.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"JJ" wrote in message
oups.com...
Ok. Heres what i want to do.

I have a variable number of sheets with variable names.

I want to at runtime produce a form which lists all the sheets and a
check box for each one.

this is for my users to select which of there sheets they want to run
the macro on.

Can any one point me in the right direction ?

Or is there a better way to do this?

Thanks in advance!

J