What is vba it is the programming language embedded

This preview shows page 3 - 7 out of 14 pages.

What is VBA?It is the programming language embedded in Excel.What isn’t VBA?
How long has VBA been around?
47That depends.What do we use VBA for?
8So, what do you have to learn?That depends.
59Data structuredata types: integer, real, string, logicalstructures: arraysobjects: classifications, properties and methodsAlgorithm structuresyntax, sequence, selection, repetitionmodular programming: procedures and functionsInput/Output and Special Featuresuser formsevent handlers10How does VBA work with Excel?Excel workbookworksheetswith cellschart sheetswith graphsVBA Projectmoduleswith proceduresand functionsOption AOption BOption COKOption AOption BOption COKOKOption AOption BOption COKOption AOption BOption COKOKuserformswith associatedVBA codeExcel ApplicationSpreadsheetenvironmentVBAenvironment“Spreadsheet world”“VBA world”
611The Visual Basic Editor (VBE) is used to manage theVBA environmentlaunching the VBEAlt-F11shortcutThe Visual Basic Editoropens in a separate window.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture