Book Online Tickets for Excel VBA Macro Training for Working Pro, Chennai. Excel VBA Macro Training Training Date: May 18th & 19th 2019 Timing: 9:30AM - 5:30PM Location: Excel Prodigy, Valasarawakkam Training Fee: Rs. 6,500 Participants will be served with Lunch & Refreshemnt for Both Days Introducing th

Excel VBA Macro Training for Working Professionals on May 18th 19th 2019

Saturday, 18th May 2019 - Sunday, 19th May 2019 | 09:00 AM to 06:00 PM IST
Excel Prodigy Training Consultancy Private LimitedNo:109, Chowdri Nagar Main Road, Valasaravakkam, Chennai, Tamil Nadu, India

 

  • Registration

    Registration Amount to Block your Seat

    Sale Date Ended

    INR 1000
    Sold Out
Event ID : 199979

Invite friends

Contact Us

Page Views : 20

About The Event

Excel VBA Macro Training

Training Date: May 18th & 19th 2019

Timing: 9:30AM - 5:30PM

Location: Excel Prodigy, Valasarawakkam

Training Fee: Rs. 6,500

Participants will be served with Lunch & Refreshemnt for Both Days

    • Introducing the VBA Editor
    • Recording Macros in Excel
    • Running Macros in Excel (Shortcut Keys, Menu, Toolbar)
    • Understanding the syntax of VBA
    • Using Variables in Visual Basic
    • Commenting your work
    • Introducing Objects, Properties, Methods
    • The Range Object
    • Use the Cells Property, Offset Property
    • Using Variables in the For Statement
    • Variations on the For...Next Loop
    • Exiting a Loop Early After a Condition Is Met
    • Nesting One Loop Inside Another Loop
    • VBA Loop: For Each
    • VBA Loop : Do Loops
    • Flow Control: Using If...Then...Else
    • Flow Control: Using Select Case
    • Using the Msgbox
  • Using the Inputbox
  • Creating and using a user-defined function
  • Enabling Events
  • Workbook Events
  • Worksheet Events
  • Creating User Forms
  • Using Form controls
  • Debugging and Error Handling
  • Excel Macro Project

More Events From Same Organizer

Similar Category Events