Share via

What is the VBA Version associated with Excel 2016

Anonymous
2018-07-16T15:17:45+00:00

Got to love Google. I tried this same question and got hundreds of responses on how to use VBA to find the version of Excel I am using.

I am trying to use some code written in 2002 which says #IF VBA6 ... and the else is for if you are using an earlier version. I am hoping the whatever version of VBA I have is backwards compatible to VBA6.

I was able to find that VBA7 was associated with Excel 2010.

I can comment out the code, but I'd still like to know how to find out what version of VBA I am using.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2018-07-16T16:45:07+00:00

Hi Dan,

Excel 2016 rely on VBA v.7.1. You can check it by opening Help/About menu in Excel Visual Basic.

Was this answer helpful?

10 people found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Charles Kenyon 167.5K Reputation points Volunteer Moderator
    2018-07-16T18:14:06+00:00

    See https://msdn.microsoft.com/en-us/vba/language-r....

    The constant for Office 2016 is Vba7.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2018-07-16T16:10:46+00:00

    Have you seen this post:

    http://www.vbaexpress.com/forum/showthread.php?...

    Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

    Was this answer helpful?

    0 comments