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 Chriss Miller 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
Feb 2, 2002
28
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
Catching the Mouse Click Error in Modal User Form
Replies
1
Views
572
strongm
strongm
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
529
Andrzejek
Andrzejek
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
984
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
Do we have a VBS version of listing files in a folder?
Replies
2
Views
330
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top