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've done that before. Usually it was $$$

 

[JenniferMurphy]

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']

View attachment 13850

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

Well, I'll be damned (most likely). It works.

Thank you for that.

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

IMHO, this makes them substantially more jerky. This has to be one of the most geeky implementations I have ever seen. It's obtuse beyond even M$FT standards.

If they were going to allow user-defined keyboard shortcuts, why not use a procedure similar to what they already have in Excel and Word?

And why do I have to give up the icon grossly using up limited toolbar space? So they can display the "B"? Stupid. Just display the shortcut, if any, when I hover over it.

I am glad to have this tool, but it does not at all improve my assessment of the VBA developers.

 

[JenniferMurphy]

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

I've done that, too. It has the advantage that those markers persist after the IDE is closed, whereas the bookmarks do not.

 

[Jeffrey Mahoney]

I've worked with the strangest applications out there. MS products have so many features that work well in comparison to the ones that don't. I'm happy to have a solution even if it's not a perfect one.

 

[JenniferMurphy]

I did a little experimenting and found that I can change the text to something shorter, like &BM, to save space on the toolbar.

 

[Peter_SSs]

IMHO, this makes them substantially more jerky. This has to be one of the most geeky implementations I have ever seen. It's obtuse beyond even M$FT standards.

If they were going to allow user-defined keyboard shortcuts, why not use a procedure similar to what they already have in Excel and Word?

I don't think it obtuse. It is identical (as far as I can remember) to how you could modify Toolbar images, text and shortcut character in Excel/Word etc before the introduction of the ribbon.
I would definitely not like to see the same arrangement that exists now in the applications themselves where for the vast majority of items on the ribbon or QAT you cannot modify the image, the tool tip text or the shortcut key. For those where you can modify the image all you can do is choose from a set list of a couple of hundred icons. Here (ie vba) you can modify the text and shortcut character pretty much at will and can modify the image with virtually infinite possibilities.

And why do I have to give up the icon

Actually, you don't. Choose 'Image & Text' rather than 'Text Only (Always)' that I suggested earlier. Then you could reduce the text further to just '&B' if you are trying to save space since you now again have the image as your reminder of what the button is.

And, as I mentioned, you can do what you like with the image. Say you want it to stand out a bit more compared to the other bookmark icons ..

or even use a familiar image

 

[JenniferMurphy]

I don't think it obtuse. It is identical (as far as I can remember) to how you could modify Toolbar images, text and shortcut character in Excel/Word etc before the introduction of the ribbon.

No, absolutely not. In Word, where I have a lot of personal shortcuts, the procedure is fairly user friendly, at least by M$FT standards. Go to Options (Alt+f, t). Click on Customize Ribbon, then Keyboard Shortcuts: Customize (at the bottom). Find the command or macro you want. The current shortcut will be displayed in the Current Keys: box. If you want to assign a shortcut, click in the Press new shortcut key field and type it. And all three control key combinations are available.

I agree that Excel is a mess. More little goodies from the jerks.

And what about the vaunted compatibility among the office apps. Total BS. Woody Leonhard wrote a book way back in 1994 documenting hundreds (thousands?) of bugs in Word, many of which are still bugs today.

Actually, you don't. Choose 'Image & Text' rather than 'Text Only (Always)' that I suggested earlier. Then you could reduce the text further to just '&B' if you are trying to save space since you now again have the image as your reminder of what the button is.

View attachment 13997

Nice

And, as I mentioned, you can do what you like with the image. Say you want it to stand out a bit more compared to the other bookmark icons ..
View attachment 13998

or even use a familiar image
View attachment 13999

Cute.

 

[Jaafar Tribak]

I miss the way we could easily edit & program excel's commandbars before the ribbon