Dynamically generate forms in Excel using VBA

Question

I am trying to find or develop some VBA to dynamically create form fields (shortcuts and text fields).

The source data is tables on a hidden Excel sheet.

Any ideas?

Answer 1

You can create new elements in the Forms Controls collection using the Add method, which determines the type of control using the CLSID.

In this article Dynamic Excel Forms using VBA there is sample code.