After typing the first few letters, press Ctrl+Space.Start typing a line of code like ActiveCell.To use the Ctrl+ Space shortcut in the VB Editor: When we are typing code, Ctrl+ Space opens the Intellisense drop-down menu that contains a list of matching objects, properties, methods, constants, and variables. This is definitely one of the keyboard shortcuts I use the most in VBA. There is also a video in that series on how to add macro buttons to a custom ribbon.

We can store this macro in our PMW and assign it to a button in the ribbon or keyboard shortcut, and then run it any time on any open workbook.Ĭheckout my free video series on how to create your Personal Macro Workbook to learn more. I like to think of the PMW as our Excel tool belt that can save us time with task we do every day.įor example, I have an article with a macro that creates a list of unique values on a new blank sheet. We can also create custom toolbars with buttons to run our macros. This workbook opens in the background every time we open Excel, making our macros easily accessible. The Personal Macro Workbook (PMW) is a great place to store the macros you use often. #2 – Store Your Macros in The Personal Macro Workbook Some laptops have a Fn Lock feature that makes the function keys primary, which means you won't have to press the Fn key when pressing F1-F12.Ĭheckout my article on the Best Keyboards for Excel Keyboard Shortcuts to learn more. The function keys on laptops are typically multi-use keys, and require the Fn key to be pressed to activate the function keys ( F1– F12). If you are using a laptop keyboard then you might also need to press & hold the Fn key before pressing F11. If you don't see the Developer tab in the Ribbon, click the image to learn how to enable it: The Fn (Function) Keys on Laptops The shortcut in the Mac version is Opt+ F11 or Fn+ Opt+ F11.

The keyboard shortcut to open the VB Editor in any Windows version of Excel is Alt+ F11.

It can be opened by clicking the Visual Basic button on the Developer tab in Excel. The VB Editor is the application we use to write macros and create userforms. Ctrl+J Opens the Intellisense Drop Down.Automate Repetitive Tasks with The For Next Loop.Store Your Macros in The Personal Macro Workbook.18-Excel-VBA-Macro-Shortcuts-for-2018-Excel-Campus.pdf Download Page Index

Text box vba excel for mac