Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to get all the HelpContextID's or Tags of all the userforms
in a project? I can get all the names of all the forms, but sofar no success to get the HelpContextID's or Tags. Sub test() Dim oVBProj As VBProject Dim oVBComp As VBComponent Set oVBProj = ThisWorkbook.VBProject On Error Resume Next For Each oVBComp In oVBProj.VBComponents If oVBComp.Type = 3 Then MsgBox oVBComp.Name End If Next End Sub Thanks for any advice. RBS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
name tags | Excel Discussion (Misc queries) | |||
SMART TAGS | Excel Discussion (Misc queries) | |||
Smart Tags | Excel Discussion (Misc queries) | |||
Smart Tags | Excel Worksheet Functions | |||
Smart tags | Excel Worksheet Functions |