Find code object : VBE « Application « VBA / Excel / Access / Word






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

Find code object

 
Public Sub FindCodeObject()
  Dim component As VBIDE.VBComponent
  Set component = Workbooks("Book1.xls").VBProject.VBComponents(Workbooks("Book1.xls").CodeName)
  Debug.Print 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.Get VB project name
5.Get active project name
6.Find user form
7.Find worksheet code module
8.Clear Immediate window through VBE
9.Displaying each active VBA component in a worksheet