Adding the names of all macros in current workbook into a combobox

[lordterrin]

Hi There,

I'm piecing together a few different macros that I have in an attempt to build a new one, and I'm running into a problem that I can't figure out.

I have a button on a worksheet that launches a UserForm to have the user select which workbook they want to run a given macro on. The code, here:

Please Login or Register  to view this content.

works just fine. There are no issues with this.

Right below that box is another button that prompts the user to select which macro they want to run on the book they selected in the first box.



My second button, UserForm2, has the following code, which is NOT working properly:

Code:

Please Login or Register  to view this content.

If I run the two subs ListofMacros and GetTheList outside of the userform, (in a module by themsleves), that I got verbatim off this forum - they work fine. They provide back to me the names of all the macros currently running in the active workbook. This is CLOSE to what I want - but instead of a msgbox, I want it to populate the combobox so that the user can select one.

Since the MsgBox is giving back the variable list, I assume that list is the variable where the data is held - so I could use that in the combobox - but I'm getting something wrong.

The code to actually provide the list of macros is too complicated for me to understand line by line, but this part:

Code:

Please Login or Register  to view this content.

seems like it should be working. However, when I click the button to launch UserForm2, the combobox is empty, and I'm not sure where I'm going wrong.

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

[lordterrin]

You are the man. I could not for the life of me figure out where that text needed to go. Thank you!

[AlphaFrog]

You're welcome.