Archive Collection: Quick Tips

I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Quick Tips.

Archive Collection: Quick Tips

From September 1, 2020, through April 27, 2024, I posted an article here every single day.  Beginning on April 28, 2024, I started slacking by taking off Sundays.  So, while my daily streak has been broken, I still have an automated weekly email that goes out every Sunday morning and includes details of the last six articles I've posted. (You should sign up for it if you haven't already; just hit the [Subscribe] button above.)

In other words, I still need to post a new article every Monday through Saturday or my weekly email doesn't work right.  I'm currently on vacation, though, which makes maintaining this streak a bit...tricky.

I don't want to be writing and publishing articles on vacation.  And I still want to provide you with something of value to read each day.  So I settled on creating a series of curated article lists that I think you'll find beneficial.

I'm hoping at least some of these articles are ones you haven't read before.  And if you're so obsessed with me that you have read all my articles, I'm hoping that they'll keep you busy enough that you don't come looking for me and my family 😳.  


Quick Tips

Shortcut Key to Comment/Uncomment Blocks of Code in VBA
You don’t need 3rd-party tools to add keyboard shortcuts for commenting and uncommenting code blocks in VBA with this trick.
Quick Tip: Set Next Statement with Mouse
Try this tip the next time you use the Edit & Continue feature when debugging. After more than 15 years of developing VBA, I’m still learning new things.
Quick Tip: Instant Find in the VBA IDE
Somehow I went more than 20 years writing code in VBA without knowing about this handy shortcut key.
QuickTip: Navigation Captions
Even after 17 years of developing in Microsoft Access, I’m still learning about features that have been there the whole time...
Inserting a Blank Line in the VBA Immediate Window
Did you know you can insert a newline character in the Immediate Window without executing the current line of code?
Quick Tip: Alt Codes in Windows
Checkmarks, bulleted lists, section symbols, pi, daggers, copyrights, etc. Each of these symbols can be entered in Windows using an easy keyboard shortcut.

Additional Reading

Quick Tip - No Longer Set
Articles with quick tips that you can easily incorporate into your development workflow.

All original code samples by Mike Wolfe are licensed under CC BY 4.0