Auto-generate controls on form

[JJ]

How do I write code to put a control (like a textbox) on a
form?

I have a list of fields and would like to create textboxes
on a form for each field - like the wizard.

Any sample code on how to get the form object and how to
create a textbox is appreciated.

 

[Tom Ogilvy]

See John Walkenbach's site for an example:

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