i used all the letters for CNTRL+SHIFT+letter how to write more macros?

[Tody03]

I am using a personal.xlsb and load it every time I run my project. I activate the macros by using cntrl-shift+letter. I have already more than 26 macros connected with the specific project. How can I write more new macros? And run them from the same personal.xlsb?

 

[alansidman]

You can trigger them with Command Buttons or you can trigger them by clicking on Alt + F8 and then selecting the appropriate Macro. When you use your method, you replace the keyboard shortcuts established by Microsoft.

 

[steve the fish]

You dont need to assign all macros a shortcut. Also you dont need to use capital letters to assign a shortcut.

 

[diddi]

create a userform menu with commandbuttons that allow the user to chooses a task

 

[L. Howard]

Maybe you can work with something like this Select Case method from a drop down with "AA", "BB", "CC" as selectable items. (with three mini subs as a demo).
Copy to the sheet with the Drop Down in B2
The "AA" item/s could instead be a short description of what the macro does.

Howard

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("B2")) Is Nothing Then

        Select Case Range("B2")

            Case "AA": Macro1
            Case "BB": Macro2
            Case "CC": Macro3

        End Select

    End If
End Sub

Sub Macro1()
MsgBox 1 & " " & "KIM"
End Sub

Sub Macro2()
MsgBox 2 & " " & "DOM"
End Sub
Sub Macro3()

MsgBox 3 & " " & "HOWARD"
End Sub

 

[Tody03]

so how can i activate the macro in the fastest way?

 

[Tody03]

thanks i will try it

 

[alansidman]

Alt + F8 or create some Icons on the QAT for the most used macros.

 

[Tody03]

thanks. i tried it - it is very simple. now i have to get used to it.

 

[Tody03]

what is QAT