Record Macro Excel. Record a macro in excel. Go to the view tab of the ribbon and click the tiny arrow below the macros button.
To tie your macro to a keyboard shortcut type a letter. When a macro is recorded it can be used again by assigning a keyboard shortcut or from the view macro function. And excel will translate that into vba code creating a new module into your vba project.
Formatting selected cells etc.
And while you can code a macro using visual basic for applications vba excel also lets you record a macro by using standard commands. And while you can code a macro using visual basic for applications vba excel also lets you record a macro by using standard commands. This will open the record macro dialog box. I am using the name entertext.