View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt Somers Matt Somers is offline
external usenet poster
 
Posts: 4
Default Checking for VBA5, not VBA6

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