Pop Up Menu with multiple macro buttons

[shindig54]

Hello,

I have built a planning model that has quite a few macros that move around, display, hide, and consolidate budget data. In order to make it easier for the user to navigate the macros, I have created command buttons but there are so many. I was wondering if there is a way to create a "switchboard" or some kind of menu that pops and shows all the macro buttons so they are not taking up real estate on the actual spreadsheet.

Thanks so much,
Shin

 

[NoSparks]

I would put all the macro buttons on a user form and use a single button or key combination to show that user form.

 

[tonyyy]

Another approach would be to use an InputBox...

Sub ChooseMacro()
Dim answer As Long
answer = Application.InputBox(prompt:="1 - Macro01" & vbCrLf & "2 - Macro02", Type:=1, Title:="Please enter a number:")
If answer = 1 Then
    MsgBox "Call Macro01"
ElseIf answer = 2 Then
    MsgBox "Call Macro02"
End If
End Sub

Cheers,

tonyyy