vba — Andrew Moss

Excel

Keyboard Shortcut for VBA Comments

Monday 28th March 2022Sunday 15th October 2023

VBA lacks a keyboard shortcut for commenting. This is a standard feature in modern IDEs, however, the VBA Editor is not modern, so we are forced to tolerate its drawbacks. Comments are denoted using a single quotation mark (‘). Block…

Uncategorised

How to Build a Custom Ribbon in Excel

Monday 25th January 2021Tuesday 4th July 2023

Microsoft’s ribbon interface has been with us since the launch of Office 2007. Although met with mixed reaction, over time many acknowledged it was a viable replacement for the ageing bland menus we had become accustomed to. Microsoft developed the…

End of content