Show selected VB component's name : VBE « Application « VBA / Excel / Access / Word






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

Show selected VB component's name

 
Public Sub ShowNames()
  With Application.VBE.SelectedVBComponent
    Debug.Print .Name & ": " & .Properties("Name")
  End With
End Sub








Related examples in the same category

1.Find the code pane
2.Find the selected component in VBIDE
3.Find code object
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