Auto-generate controls on form
 

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.

Auto-generate controls on form
 

See John Walkenbach's site for an example:

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

--
Regards,
Tom Ogilvy


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