Macros VBA (For Non-Programmers)

by Trainocate India Claim Listing

This course will help to write macros in Excel using programming language Visual Basic Application (VBA). Recorded macro can edit to customize it to fulfill our requirement and one can directly go for coding to accomplish the required tasks.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Trainocate India Logo

img Duration

3 Days

Course Details

This course will help to write macros in Excel using programming language Visual Basic Application (VBA). Recorded macro can edit to customize it to fulfill our requirement and one can directly go for coding to accomplish the required tasks. One can write his own functions and procedures, design forms and working with add-ins using VBA Macro.

 

Objectives:

  • Write macros to automate routine work. 
  • Create functions and procedures 
  • Design and use forms for data entry 
  • Create add-ins to deploy at client machines 
  • Create reports

 

Content:

  • Module 1: Understanding Security Levels
  • Why security
  • Security levels and its meaning
  • Module 2: Functions
  • What is Function and Subroutine
  • Writing Functions using VBA Editor
  • Calling function in other workbook
  • Module 3: Recording Macros
  • Recording and running macro
  • Storing macro in different books
  • Creating buttons and assigning macro to it
  • Creating My Menu
  • Module 4: The Visual Basic Editor
  • Editing macros using VBA Editor
  • Understanding the project explorer
  • Exploring windows properties
  • Modifying code in code window
  • Debugging code
  • Module 5: Programming Fundamentals
  • Variables, data types and constants
  • Arrays
  • Object Variables
  • Conditional structures (If …. Then, Select Case)
  • Logical Operators
  • Looping constructs (For loops, Do loops, While loops)
  • Built-in functions 
  • Creating Subroutines
  • Module 6: Excel Object Model
  • Working with objects – properties, events and methods
  • Application objects
  • Workbook objects, Worksheet objects and Range objects
  • Charts objects
  • Pivot table objects
  • Module 7: User Forms
  • Creating forms
  • Form events
  • Creating custom menus and toolbars
  • Creating Add-ins
  • Module 8: Working with other applications
  • Working Word, PowerPoint and other applications
  • Bangalore Branch

    Royal Barter, 1st Floor No 78/1, Residency Road, Bangalore
  • Chennai Branch

    4th Floor, 4 - 417, Workafella | Nungambakkam No 10, Uthamar Gandhi Salai, Chennai
  • Mumbai Branch

    7th Floor, 7 - 120, WeWork, Zenia Building, Mumbai

Check out more Visual Basic courses in India

KVCH Logo

Drupal Training

KVCH is the pioneer of education providing the best Drupal training in Noida as per the current industry requirement that enables candidates to land on their dream jobs in companies worldwide. KVCH Provides best Drupal training course in Noida.

by KVCH [Claim Listing ]
I-Net infotech Logo

PHP Course (Advance)

PHP is a scripting language originally designed for producing dynamic web pages. PHP was originally created by Erasmus Leadoff in 1995, the main implementation of PHP is now produced by our PHP training center Group there is no formal specification.

by I-Net infotech [Claim Listing ]
Tech Altum Logo

JQuery Course

JQuery is a most popular Javascript library used for wide range of actions like event handling , DOM manipulation, animations, and ajax interaction, for faster web applications. JQuery can simplify javascript as jquery syntax is light weight and easy to use.

by Tech Altum [Claim Listing ]
Argus Academy Logo

PHP

PHP is an intuitive, server side scripting language. Like any other scripting language it allows developers to build logic into the creation of web page content and handle data returned from a web browser.

by Argus Academy [Claim Listing ]
Lal Bhadur Shastri Training Institute Logo

Visual Basic

Visual Basic course is offered by Lal Bhadur Shastri Training Institute

by Lal Bhadur Shastri Training Institute [Claim Listing ]
  • Price
  • Start Date
  • Duration

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy