Building a form on the fly

[Steven Revell]

Hi All,

I was wondering if it is possible to build a form on the
fly if it is not already created.

I want to be able to use a worksheet called "Setup" to
create a form. The setup sheet will be different and is
imported from another workbook. It is of the form:

Project | Director | Doc Type
------------------------------
| Person 1 | Word
| Person 2 | Excel

Where the titles are the control names and if there are
values under the titles they are combo boxes. The values
under the titles are values avaiable in the combo box.

Thanks in advance for any help,

Steven

 

[Bob Phillips]

Steven,

John Walkenbach has a page on building a userfortm programmatically at his
website at http://j-walk.com/ss/excel/tips/tip76.htm