Run any macro from one button | 🤯 | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★

★ Check out the blog post★

★ About this video ★
Normally in Excel, one button does one thing. But what if we want it to do more than one thing? Further, what if we want the user to be able to choose what this button is going to do? Well, in this video, we show you how to make one button run any macro.

0:00 Introduction
0:19 Example
1:12 Setup
2:38 Building the solution
5:29 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★

★ Where to find Excel Off The Grid ★

#MsExcel

[ianl]

One button for them all..."my precious".
Great video. Thanks for your time and effort.

[IvanCortinas_ES]

Another great tutorial with a lot of added value. Spectacular operation of the macro. Thank you very much Mark.

[EricHartwigExcelConsulting]

Now this is really cool! I can not wait to start using it!
Thank you for creating/sharing this Mark!

[kebincui]

Excellent video. Thanks our clever Mark for sharing this trick. Looking forward to more! ❤👍🌹☺️

[wmfield]

Great (& useful) trick, Mark. Thanks again for sharing your knowledge.

[Rice]

Good idea for calculating processes with several steps. :)

[Nevir]

Thanks, wasn't really looking to do THIS but it let me implement what I wanted.

A macro that will only execute when a certain state is present in the sheet, (which is checked by formulas on the sheet itself, which is what I'm looking at.) and otherwise launches a customized error message telling them to look at the messages and fix it before trying again.

[micheltw]

Could this be done with an office script button?

[paulmartinlife]

Very nifty, though I see a potential (and not improbable) issue with this solution as the image name refers to a cell which could be changed. If a column is inserted before col. F, for example, the code fails. A useful presentation nonetheless, which I could apply. Thanks again, appreciated...

[mrfish_]

Exacly one week ago i wrote macro with this same concept, but i running userforms after select shapes.

Public Sub RunForm()

Dim strShapeName As String
Dim shpSelected As Shape

strShapeName = Application.Caller

Set shpSelected =

Select Case shpSelected.name
' after select shapes with name getQuery, userform with name getQuery shows up
Case "getQuery"
getQuery.Show
Case "addQuery"
AddQuery.Show
End Select

End Sub