What is the difference between a VBA project and a VBA macro?

Asked

Viewed 3,784 times

3

was studying macros VBA and came to me the following doubt: What is the difference between a VBA project and a VBA macro?

Are the two the same or have some significant difference between them?

vba

  • What can cause confusion between the terms is that there are those who consider macro only those recorded by the macro editor, but in fact those that you program (what would be the "vba project") are also macros.

2 answers

4


I’d say they’re not the same:

VBA Project

A project is a set of "objects" that can contain Macros.

  • then it would be correct to state that a VBA macro is a programming routine, while a VBA project is the junction of several macros and other objects such as files and images for example?

  • 1

    Yes, macros are programming routines. The project may contain objects such as modules that contain macros or Forms that are user interfaces that also include code (VBA). In the image above you see the structure of a VBA project of an excel file.).

2

They are the same thing, VBA - Visual Basic For Application, is a programming language used by microsoft that runs behind its office application and others, so to Voce have a VBA Voce project will create some macros, in case subroutines

Browser other questions tagged vba

You are not signed in. Login or sign up in order to post.