PDA

View Full Version : Calling a macro within a macro



WilliamKWell
01-28-2021, 07:05 AM
I have created a listbox with two columns, in column one is a description of a macro, in column two is the actual spelling (name) of the macro.

I know how to retrieve the name of the macro as a string, Y = ListBox1.Column(1, X) 'retrieves value of 2 column of item selected in list box.

However, using Call Y does not run the macro selected.

Any ideas how to run the selected macro?

Bob Phillips
01-28-2021, 07:55 AM
Try using Application.Run "macroname"

WilliamKWell
01-28-2021, 08:11 AM
Good gosh, so easy and I looked right over that! Thank You Thank You Thank you

:beerchug: