See John Walkenbach's site

http://j-walk.com/ss/excel/tips/tip76.htm
Creating a Userform Programmatically

--
Regards,
Tom Ogilvy

"Ed" wrote in message
...
I have single-row item entries on the front sheet, with each one named as
a
separate range. Each item will then be tracked on a separate sheet, with
values and such showing up on the front sheet. I'd like to use a Form to
set an action and quantity for the individual item.

Is it possible to open a UserForm that will list all the ranges - whether
2
or 20 - as check or option boxes, and for each range give text boxes to
allow input?

Ed