if i go into the vbe and write a code, how can i add a shortcut key to it?

my code in my personal.xls file :

module filter
Sub Vendor()

Dim s As String
s = InputBox("Enter vendor search value", "Searching on vendor")
Selection.AutoFilter Field:=2, Criteria1:="=" & s & "*", Operator:=xlAnd

Range("A1").Select
End Sub

I want to add a shortcut key but how?

....changing

Changing? and that means?

With your personal.xls (code) file open. Select from the Tools Menu: "Tools-Macro->Macros...", or use {Alt+F8} keys. This will open the Macros dialog window showing a list of availabel macros.

Find the name of your macro you want to add the shortcut key to. Select it.

The 'Options...' button will be enabled. Click it.

Enter a key combination to use as the shortcut.

You may need to close and restart your file to have the changes take effect.

Its a good idea to try your shortcut combination prior to assigning it to a macro to check if you are setting something already used as a shortcut.


~

I had a senior moment...