How can i get a list of Additional Controls with a VBA Code?

[Erdin? E. Ka]

Hi everyone! :hi:

This time i need a help about VBE Window | Insert | UserForm | ToolBox | Controls | "Additional Controls".

I think it's a similar problem to my previous question, but i couldn't find a solution for this. :think:

How can i get a list of "Additional Controls" to a worksheet with a VBA Code?

Also, i want to get the Name, Location, Full Path etc.. properties of all "Additional Controls".

I am sorry for my insufficient English.:dunno
Thanks... :help

[webtubbs]

This macro will return all of the additional controls available....

Sub GetAdditionalControls()
Dim cmd As CommandBar
Dim cb As CommandBarComboBox
Dim i As Long
Set cmd = Application.CommandBars("Control Toolbox")
Set cb = cmd.Controls("More Controls...")
For i = 1 To cb.ListCount - 1
Cells(i, 1) = cb.List(i)
Next
End Sub

I'm not sure how to get the remaining information though.

Hope this helps.

Wayne

[Erdin? E. Ka]

Hi Wayne,:hi:

Thank you very much for your help. This macro is partly solved my problem.:friends:

Now i must find remaining informations, particularly full path. Full path is the very important for me.:doh:

But i want thank you very much again for your help. :yes

Yours very truly.