Hi Bill

For such a limited task, I believe I'd create 7 boxes and set the visibility
to False for the ones I don't need at runtime. But sure, see John
Walkenbach's code at
http://www.j-walk.com/ss/excel/tips/tip76.htm

HTH. Best wishes Harald

"Bill" skrev i melding
ink.net...
Hello All,
Is there a way to use VBA to add a certain number of checkboxes (or
anything
else) to a userform? For example, I may need anywhere from 3 to 7
checkboxes on a userform. I would prefer to build just one instead of 5
different userforms.

Thanks for the help.

Bill