There isn't a compiler constant named VBA5. You can only use VBA6.
In VBA help, do a search for #If, then look under "See Also" for Compiler
Constants

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Matt Somers" wrote in message
om...
Thanks to Tom Ogilvy, I understand you can check for VBA6 using:

#If VBA6 then

Msgbox "Yes"

#Else

Msgbox "No"

#End if

When I replaced the "VBA6 with "VBA5" in Excel 97, the code returned "No".

Am I properly referencing the version by entering VBA5?
Should I be checking something else? Is it VBA5.0, I don't know.

Thanks,

Matt