Keyboard shortcut to toggle VBA bookmarks

[JenniferMurphy]

Is there a VBA IDE keyboard shortcut to toggle bookmarks? If not, can I assign one?

This website claims to list all of the VBA shortcuts, but bookmarks are not listed. Someone asked about bookmarks, but never got an answer.

Complete List of Excel VBA Editor Keyboard Shortcuts - ExcelBaby

The complete list of Excel VBA Editor (VBE) keyboard shortcuts are for U.S. keyboard layout and Windows Operation system. See also: Complete List of Excel

www.excelhowto.com

 

[Jeffrey Mahoney]

I believe MS neglected to create keyboard shortcuts for that. Do you have the EDIT toolbar on in VBA? It has the bookmark icons

I'm a keyboard person also. Keyboard is faster than mouse clicks everyday.

 

[JenniferMurphy]

I believe MS neglected to create keyboard shortcuts for that.

Just one of many neglects. The jerks also neglected to provide me with a way to define my own shortcuts. I guess they were too busy counting their stock options.

Do you have the EDIT toolbar on in VBA? It has the bookmark icons.

I'm a keyboard person also. Keyboard is faster than mouse clicks everyday.

Yep, I have the icons, but, as you say, a keyboard shortcut is faster. It's also more accurate.

 

[Jaafar Tribak]

I was thinking maybe one could add a custom control to the VBE Edit commandbar, assing an OnAction and a ShortCutText Properties to it and the OnAction Property would just execute the tooglebookmark button via the Execute Method.

After a little test, I found that custom vbe controls do not respond to the shortcut keys even if you set their ShortCutText Property.

 

[RoryA]

Alt+EBT is the only one I know of.

 

[Peter_SSs]

The jerks also neglected to provide me with a way to define my own shortcuts.

The 'jerks' are perhaps not quite as thoughtless as you give them (dis)credit for.

If you have the Edit toolbar visible, right click -> Customize -> be on the Commands tab
Select the 'Toggle Bookmark' icon up on the Edit menu
Back at the Customize interface -> Modify Selection -> Change from Default Style to Text Only (Always) -> click Modify Selection again -> in the Name box, move the ampersand from in front of the T (clashes with activating Tools menu) to in front of the 'g' (at least that is where I put it) [Edit: Though probably in front of the B might be more intuitive for 'Toggle Bookmark']

Close the Customize dialog.
Alt+g should now toggle bookmarks.

 

[Jeffrey Mahoney]

Oh, I gotta try that.

 

[Jeffrey Mahoney]

I had to make some other selections before getting where you were. It worked.

 

[Peter_SSs]

I had to make some other selections before getting where you were.

Perhaps I had done that years ago & forgot about it?

 

[Fazza]

I didn't know there were bookmarks. On the very few occasions I've used this soft of thing over the years, I type in a comment like
'sh!t
and then when I need to find it, use the find dialog box. delete it entirely after debugging