Find user form : VBE « Application « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Application
  3. VBE

Find user form

 
Public Sub FindUserForm()
  
  Dim component As VBIDE.VBComponent
  Set component = Workbooks("Book1.xls").VBProject.VBComponents("UserForm1")
  MsgBox component.Name
End Sub








Related examples in the same category

1.Show selected VB component's name
2.Find the code pane
3.Find the selected component in VBIDE
4.Find code object
5.Get VB project name
6.Get active project name
7.Find worksheet code module
8.Clear Immediate window through VBE
9.Displaying each active VBA component in a worksheet