Dynamic generation of Forms in Excel using VBA

Question

I'm trying to find or develop some VBA to dynamically generate form fields (labels and textboxes).

The source data is a table on a hidden Excel worksheet.

Any ideas?

Answer 1

You can generate new items in the Forms Controls collection by using the Add method specifying the type of control using its CLSID.

This article Dynamic Excel Forms using VBA has some example code.