Enumerate Controls on a Form

[tcb]

I would like code that would enumerate all controls on a form
returning their names and types.

Thank you.

 

[Arvin Meyer [MVP]]

You should be able to figure it out from the code at:

http://www.datastrat.com/Download/FixNames2K.zip

 

[KARL DEWEY]

Try the TOOLS - Analyze - Documenter.

 

[Allen Browne]

Dim ctl As Control
For Each ctl in Me.Controls
Debug.Print ctl.Name, ctl.ControlType
Next

Here's a function that shows the name instead of the number of the control
type:
http://allenbrowne.com/ser-73.html#ControlTypeName