I have looked for a list of bugs & idiosyncrasies and I haven't found one, which is odd since the program has been out for 25 years. With all of the great posters here maybe we can generate such a list (or you can point me to one if it already exists).

I'll start with 2:

1) VB6 and VBA don't let you enter a constant value for the most negative allowable Currency value (see this thread). A workaround is to not have the value as a constant but as a variable (say cTiny) and then assign it like:

Code:
cTiny = CCur("-922337203685477.5808")
2) The IDE changes the capitalization of all references to an Enum defined in your code to be whatever the last typed entry is. The best workaround for this I have seen is to define the Enum values as variables within a conditional compilation value that is always False (the code doesn't get included in your code but VB honors the declaration). To me that's weird but it works.

Any others?