I just saw a note about VBA in regards to ArcGIS 10.  Apparently it is still available, but requires a separate install and (free) license file.  So you've still got one more version to use your vba scripts, but essentially it isn't supported.  I suspect this might be available for at least one more version, because of the vast quantity of scripts available.  Then again, ArcGIS 8 got rid of their AML and ArcView's crap scripting language.