Visual Basic for Applications

获取Visual Basic的所有细节，为应用程序（VBA）

✴ Visual Basic for Applications (VBA) is a programming language that is similar to Visual Basic, only it is embedded in an individual Microsoft application such as Excel or Access. Using VBA you can create macros or small programs that perform tasks within the Microsoft application.✴

► This App has been prepared for the beginners to help them understand the basics of VBA. This App will provide enough understanding on VBA from where you can take yourself to a higher level of expertise.✦

❰ Note - Before proceeding with this Lessons, you should install MS Office, particularly MS-Excel.❱

【Topics Covered in this App are Listed Below】

➻ VBA - Overview

➻ What is VBA?

➻ How to Write Macros in Excel: Step by Step Tutorial

➻ What is VBA in a layman's language?

➻ How to Create Visual Basic for Applications (VBA) in Excel with Examples

➻ Personal & business applications of VBA in excel

➻ VBA Hello world

➻ Step by step example of creating a simple EMI calculator in Excel

➻ Excel VBA Variables, Data Types & Constant

➻ Excel VBA Data-Types

➻ Constant in VBA

➻ VBA Array: Dynamic, Multidimensional with Example in Excel

➻ Syntax for declaring arrays

➻ Array Dimensions

➻ VBA Array Demonstrated with Example

➻ Testing our application

➻ VBA Excel Form Control & ActiveX Control

➻ How to use ActiveX control in VBA

➻ Prerequisite

➻ VBA Arithmetic Operators: Modulus, Multiplication, Division, Addition

➻ VBA String Operators

➻ VBA Comparison Operators

➻ VBA Logical Operators: AND, OR, NOT

➻ Excel VBA: Call a Subroutine

➻ Excel VBA Function Tutorial: Return, Call, Examples

➻ Excel VBA Range Object