Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Syntax (probably BNF) spec of VBA ?

I have to maintain a portion of Access 2003 VBA code, which is not my primary programming language, and while I'm pretty solid on doing regular stuff, I would still like to have a pure spec of the language syntax.. It just saves a lot of time compared to reading tons of stupid tutorials that tell me what a for loop is.

Is there any resource on the VBA syntax ? I would be happy to have it as formal as possible, probably something like BNF. I couldnt find an official spec on it.

like image 448
Jörg Haubrichs Avatar asked Oct 14 '09 18:10

Jörg Haubrichs


People also ask

What syntax is VBA?

Understanding Visual Basic syntax (VBA) | Microsoft Learn.

Which part of VBE can help you explore VBA syntax?

Component #3: Project Window / Project Explorer. The Project Window, also known as the Project Explorer, is useful for navigation purposes. This is the section of the Visual Basic Editor where you'll be able to find every single Excel workbook that is currently open. This includes add-ins and hidden workbooks.

What VBA means?

VBA stands for Visual Basic Analysis. Excel VBA is Microsoft's programming language for Office applications such as MS-Excel, MS-Word, and MS-Access. Macros are what most people who write VBA code use.


2 Answers

Check out VBA Language Specification (PDF) on MSDN.

like image 144
Nick Dandoulakis Avatar answered Nov 15 '22 11:11

Nick Dandoulakis


The Official reference is Microsoft docs

like image 38
mmmmmm Avatar answered Nov 15 '22 10:11

mmmmmm