On not using Hungarian Notation, and VBA shortcuts

In June this year Michael Alexander at Bacon Bits had a post on using Hungarian Notation (or not).  It contained the following quote from Stackoverflow, which for me sums up excellently a good reason for not using it:

“vUsing adjHungarian nNotation vMakes nReading nCode adjDifficult”

But what really made the post useful for me was a comment from Freek van Gilst, who posted a couple of very useful keyboard short-cuts available in VBA:

 When you have the cursor on a variable you can press Ctrl-i to get a tooltip with the type (and scope).
Or press Shift-F2 to jump to the declaration (and Ctrl-Shift-F2 to return to your original position).

This entry was posted in Excel, VBA and tagged , , , . Bookmark the permalink.

1 Response to On not using Hungarian Notation, and VBA shortcuts

  1. You’re welcome 🙂
    The VBA IDE isn’t as useless as one would think (given that it hasn’t changed for about two decades). And you can easily extend it. But just browsing through the menu’s you can find that they already included some useful options back in the nineties.

    Liked by 1 person

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.