Get selected macro from Application.Dialogs(xlDialogRun)

hi,

after search all over the place, I can finally show the dialog to run macros.
What I would like to do is to store the name of the macro selected in a variable.

I found someplace that when using .show, you can pass 2 parameters: "Reference" and "Step". No idea of what they do. I checked if the .show function does return something, but I just got a false, so it may not return nothing at all.

Can anyone help me out?

thank you!

That's a pitty -- what's the point of showing the dialog by macro then?
would be nice that all dialogs where a bit like userforms, so you can acces all properties and values shown.

I have developed a way to store in a sheet the list of actions to execute along with the sheets in which they have to be executed. "actions" are macros that apply to any standard sheet (sheets with certain ranges defined). Which allows me to refresh Format, formulas and so on. I wanted to be able to include a generic macro in between all those actions and I was wondering how to show a list of macros. I like to reuse whatever excel has already built, so I thought the run dialog would be a way, but apparently not. Also, for some reason it executes macros twice (!) <-- as I only need the name once, would not be such a big issue though.

I found a procedure to recover all macro names in a array and I will use a generic listbox to show them and allow user to select one.

I hoped all dialogs would be a bit like application.getopenfileName

too bad

Thanks anyway Andy

yes, that's what I will do --
I hoped excel would bring me the list of procedures, but did not get lucky on that

regards,

Well, actually I like to keep it dynamic so I do not have to update any list when I program a new procedure that acts on the whole sheet. (This functionality is basically for developers or users with technical instinct)
when I do I always define a parameter which reads "Optional Byval ws as Worksheet = Nothing" and then I initialize it int he function with actieve sheet, in case no parameter is passed.
Since I always do that then I can filter procedures and it works fairly well.

Regards!