Retrieve all form details in a project

[JumpStarter]

Hi All,

Is it possible that i can programatically get all forms (its properties and controls) that exist in a visual basic project.

Thanks in advance

 

[hmckillop]

Use the forms collection and then the controls collection within each instance of a form.

this is a vba example but replace userforms with forms and it should work

Dim frm As UserForm
Dim ctl As Control

For Each frm In UserForms
    For Each ctl In frm.Controls
      Debug.Print ctl.Name, ctl.Object
    Next ctl
Next frm

"I'm living so far beyond my income that we may almost be said to be living apart

 

[mmilan]

Be aware however that the forms collection will only give you the forms that are currently loaded in memory - which is very unlikely to be all the forms in the project itself.

mmilan