4

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?

Improve this question

1 Answer 1

Reset to default
6

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.