Find the selected component in VBIDE : VBE « Application « VBA / Excel / Access / Word






Find the selected component in VBIDE

 

Public Sub FindSelectedComponent()
  Dim component As VBIDE.VBComponent
  Set component = Application.VBE.SelectedVBComponent
  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 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