However, I understand that F8 not easily changed. As one who uses both editors, I'd like the same experience, and I can see by searchingįorums that others agree with me. Clearly, this is a bug.īy contrast, using the same editor in Windows has the very convenient F8 key as the shortcut.
Yet, if you use Microsoft Excel.app you can change the shortcut hint which appears to the right of the "Step Into" menu item within the VBE, however the keyboard shortcut does I've searched A LOTīut don't see any way to bring up "Microsoft Visual Basic for Applications" in the list of Apps available within Keyboard Shortcuts section of the System Preferences. Im a reasonably competent VBA coder, but a babe in the woods when it comes to AppleScript.
#MAC EXCEL VBA EDITOR SHORTCUT MAC#
To change the keyboard shortcut for the menu item called "Step Into" which is very commonly used while debugging and yet has the awkward 2 hand requiring shortcut "cmd-shift-i". Im running Excel 365 in both Windows and Mac environments. The System Preferences -> Keyboard -> Shortcuts and then selecting the Microsoft Excel.app, entering the Menu item and the shortcut.īut the same procedure does not work for the Microsoft Visual Basic for Application editor (VBE) which is launched while within the Excel application. I can add custom shortcuts for Excel in the normal way that is, by using
Usually to get to the Visual Basic Editor, you need to click the Visual Basic button on the Excel ribbon. I'm using the Mac version of Excel 16.29.1 on an Office 365 Personal subscription on a MacBook Pro. This tutorial will show you a variety of really useful shortcuts in VBA.
0 kommentar(er)
