If you do a lot of VBA coding, there are some improvements that I now find
it
hard to do without when working in A97. Custom events,

Custom events? Haven't seen that in A2000. What are they?

custom enumerated
types, and CallByName,

CallByName? Another new one.

to name a few. Also, having the VBE in a separate
window, though initially annoying, shows its value the first time you
debug
code behind a modal form.

Yeah, I know. For me, it's just the ability to use Alt+Tab (which I can do
without looking) to go to the code window, as opposed to Ctrl+F6 (which
requires much more work). Also, being able to have a certain form be the
current one, and a certain code module, and flip back and forth, instead of
having to scroll through all forms and code modules that are open (arggggh!
just the thought! :-) ).

Neil