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

TechiZone Logo

Web Development Using PHP / ASP.NET

Web Development Using PHP/ASP.NET course is offered by TechiZone. At TechiZone Computer Institute, we are working hard to impart practical skills to students that are always in demand by employers in various sectors and help them get Jobs.

by TechiZone [Claim Listing ]
Keywords Technologies Logo

Web Technologies

This web technology program a wide range of tools and techniques used in the process of communication between different types of devices over the internet. Some of the vital applications covered here include HTML, CSS, JavaScript, Bootstrap, and Jquery. 

by Keywords Technologies
Keywords Technologies Logo

PHP, Laravel, Ajax, Code Igniter Application Expert

This training will teach you about web application design such as HTML, Javascript, Bootstrap, CSS and Advanced Javascripts, PHP and Ajax, WordPress, JQuery, etc.

by Keywords Technologies
NobleProg (India) Logo

Drupal 7 For Developers Training Course

Online or onsite, instructor-led live Drupal training courses demonstrate through interactive discussion and hands-on practice the fundamentals and applications of Drupal. Drupal training is available as "online live training" or "onsite live training".

by NobleProg (India) [Claim Listing ]
K.S. Computer Education Center Logo

Visual Basic

Visual Basic Course is Offered by K.S. Computer Education Center

by K.S. Computer Education Center [Claim Listing ]

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