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?
From stackoverflow
-
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.
0 comments:
Post a Comment