Create Short cut key with the help of a macro

[RAJESH1960]

Hello

I assume a short cut key is created with the help of a macro in excel. I require to build a macro with lots of formulas. If I press one or more clicks on the keyboard, it displays the required data. I wanted some idea as how to create one with short cut keys. Say if I type CTRL + R+S then it should display my name Rajesh Shah. If you can share me with one macro with me or any references to learn how to create one, then, I will get an idea and try to create a macro as per my requirement.
PS. I would like to save the macro in all my workbooks by default.

 

[davesexcel]

Go to your macro list and select options to create a macro short cut key

You have a Personal Macro Workbook, you first activate the workbook by recording a macro and storing it in there.

Once in the Personal Macro Workbook you can access the macro from other workbooks

 

[RAJESH1960]

Go to your macro list and select options to create a macro short cut key

View attachment 33719

You have a Personal Macro Workbook, you first activate the workbook by recording a macro and storing it in there.

View attachment 33720

Once in the Personal Macro Workbook you can access the macro from other workbooks

I was able to create one and have saved the sheet as Excel micro enabled workbook. But when I run the macro it runs in the same cell. I want it to run in the active cell. (whereever the cursor is).
Sub Name()
'
' Name Macro
' Display Rajesh Shah
'
' Keyboard Shortcut: Ctrl+r
'
ActiveWindow.SmallScroll Down:=6
Range("E24").Select
ActiveCell.FormulaR1C1 = "Rajesh Shah"
Range("E25").Select
End Sub

 

[davesexcel]

Edit the code so it works with activecell.

 

[RAJESH1960]

Edit the code so it works with activece

 

[RAJESH1960]

ActiveCell.FormulaR1C1 = "rajesh shah"
Just one line of code. It worked
Thanks davesexcel.