Have Queries? Ask us +91 75065 23339

VBA

  • Tour of VBE (Visual Basic Editor)
  • Code Window, Project Window, Properties Window
  • Introduction to Module, User forms and Class
  • Writing First Program
  • Recording Macro
    • Absolute Recording
    • Relative Recording
  • Constraints in Naming the Macro
  • What are comment lines? and why is it required?
  • Short cut keys
  • Executing Recorded Macro, Editing the Macro, Debugging the macro
  • Macro Security
  • Running Macros from Code Window, Excel etc;
  • If..Else conditional Statement, Nested ifs
  • Select Cases
  • Looping
  • For Loop & For each loop – Do While Loop
  • Cells, Active Cells, Range, Used Range, Sheet, Worksheet, Workbook, Active Workbook, This Workbook, Applications
  • Program Structure
  • Input Box
  • Msgbox
  • File Dialogue Box
  • What is Sub? Function?
  • What is Function Definition?
  • Difference between Procedure & Function?
  • Procedure calling procedure, Procedure calling Function, Function calling procedure, Function calling Function
  • User Defined Excel Function
  • Built-in VBA function. Ucase, Lcase
  • Immediate Window
  • Variables? Importance of Variable?
  • Different types of Variables
  • Option Explicit, Option Base etc
  • Public Variable, Private Variable, Local Variable, Global Variable
  • Scope of Variable
  • Public, Private functions
  • Writing Programs in multiple Modules
  • Constants
  • Arrays (Static, Dynamic, Redim, Preserve)
  • Workbook and Worksheet Events
  • FileSystemObjects
  • User Forms
  • End To End Automation – Hands on Experience

Leave A Reply

Your email address will not be published. Required fields are marked *

Subscribe Now for Our Courses
Tell us more about your requirements so that we can connect you to the right hadoop Training in Mumbai
Name *

Email *

Mobile No:*
Courses:
Message
Contact Us
close slider

    Request a Demo

    We are glad that you preferred to contact us. Please fill our short form and one of our friendly team members will contact you back.

      Your Name (required)

      Your Email (required)

      Your Mobile Number (required)

      Subject
      OnlineOffline

      Your Message

      X