Call/Run Macro using cell's value

Need help if this is an option...

The value of I2 = Color
I have a macro named Color

I want to run the macro based on the value in I2 vs. using Call Color

Thanks,

Shane

So, basically, if you change the value on Sheet1, Cell I2, to the text, "Color" - you want it to execute a macro named "Color" or just a fix named macro? e.g. is "Color" a variable based name. If you enter "Test" in cell I2, should it then run a macro named "Test"?

If you don't have a variable name, you can use the following and place under sheet 1;

Please Login or Register  to view this content.

If you do have a variable name, you can use the following and place under sheet 1;

Please Login or Register  to view this content.

Hope this helps - please let me know if you have any questions.

TMShucks, there was latency after first post, i checked under myposts, and didn't see it, so that's why i reposted

good ol' shucks. So the code I posted here is better than your answered thread right?

Haha, my bad, but you're right, 60 isn't that bad . And yes, I have the ability to add a bit more than is necessary (a determent to my code!). Thanks for taking a look at it.