Free Excel Tips & Tricks

Subscribe to Get Daily Excel Tips & Tricks to your Inbox for Free!

Sunday, June 10, 2018

EXCEL VBA/MACROS USING SHORTCUT KEYS

EXCEL VBA/MACROS USING SHORTCUT KEYS

F5
Purpose:Use this excel shortcut key to Within the Visual Basic Editor, execute macro. F5 is also under the Navigation and Selection category.

ALT + F11
Purpose:Use this excel shortcut key to (A) If Visual Basic Editor is closed, open Visual Basic Editor; or (B) If Visual Basic Editor is open, toggle between Excel and Visual Basic Editor

ALT + F8
Purpose:Use this excel shortcut key to Display the Macro dialog box

ALT + L + I
Purpose:Use this excel shortcut key to Expand the Insert Form Controls and ActiveX Controls drop-down menu

ALT + W + M + R
Purpose:Use this excel shortcut key to Record Macro actions.

ALT + W + M + U
Purpose:Use this excel shortcut key to Use Relative References

CTRL + G
Purpose:Use this excel shortcut key to Display the Immediate Window in the Visual Basic Editor

F2
Purpose:Use this excel shortcut key to Within the Visual Basic Editor, display the Object Browser

No comments:

Post a Comment

EDITING CELLS USING EXCEL SHORTCUT KEYS

F2 Purpose: Use this excel shortcut key to Edit the active cell with cursor at end of the line. ALT +ENTER Purpose: Use this exc...