Building a form on the fly
 

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

Building a form on the fly
 

Steven,

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

--
HTH

-------

Bob Phillips
... looking out across Poole Harbour to the Purbecks


"Steven Revell" wrote in message
...
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