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).