ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   loop through form objects (https://www.excelbanter.com/excel-programming/307771-loop-through-form-objects.html)

Steven K

loop through form objects
 
Hello,

I created a form and would like to loop through each form object and get
their name and the type of object. Any help with this would be greatly
appreciated.

--
Thanks in advance,

Steven



E_R[_10_]

loop through form objects
 
For N = 0 To Me.Controls.Count - 1
Debug.Print Me.Controls(N).Name
Next

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 01:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com