get HelpContextID's or Tags of all userforms
Hi Bart,
Try inserting the following after your "If oVBComp.Type = 3 Then"
For Each p In oVBComp.Properties
'Debug.Print p.Name
If p.Name = "Tag" Then
MsgBox p.Value, , oVBComp.Name
End If
If p.Name = "HelpContextID" Then
MsgBox p.Value, , oVBComp.Name
End If
Next
Of course if you could get same from the userform object though that means
loading it.
Regards,
Peter T
"RB Smissaert" wrote in message
...
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
|