Quick Tip 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 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 Preventing Line Break After Debug.Print Statement Every time you call Debug.Print in VBA it outputs to a new line in the Immediate Window. ... But what if it didn't?!?!
Quick Tip Quick Tip: Force IntelliSense to Appear When Writing VBA Does the IntelliSense dropdown ever disappear when you're writing VBA? Do you backspace and re-type the dot to get it back? There's a better way.
Quick Tip 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 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.
Quick Tip Quick Tip: Emoji Lookup in Windows Looking for the fastest way to look up and insert emojis in Windows? This shortcut makes it quick and easy.
Code Library RegOp Quick Tip Be respectful of your user's registry. Store all your applications' settings in a dedicated publisher subkey.