Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Does Excel have a user form collection

Status
Not open for further replies.
spence27

spence27

Technical User
Joined
Feb 2, 2002
Messages
28
Location
GB
Does Excel have a user form collection, and if so how would i loop through each user form

Excel 2002
VBA
XP SP2
 
Sort by date Sort by votes
Code: 
Dim oForm As UserForm

   For Each oForm In UserForms
     Debug.Print oForm.Caption
   Next oForm

According to the Excel VBA Help, the Userforms collection holds only those Userforms that are loaded.


Regards,
Mike
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

huiettcm
  • Locked
  • Question Question
Catching the Mouse Click Error in Modal User Form
Replies
1
Views
795
strongm
strongm
IcarusHallsorts
  • Locked
  • Question Question
I have a column of data in Column A
Replies
3
Views
731
Andrzejek
Andrzejek
huiettcm
  • Locked
  • Question Question
Excel UserForm Window 'Focus' Event Listener
Replies
14
Views
1K
huiettcm
huiettcm
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
2K
remeng
remeng
feipezi
  • Locked
  • Question Question
Do we have a VBS version of listing files in a folder?
Replies
2
Views
496
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top