MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Macros & VBA Excel

Course Summary

A well designed course to learn Macros and Visual Basics for Applications in Excel


  • +

    Course Syllabus

    • Introduction
      • Introduction to VBA
      • Exercise files
    • Recording a Macro
      • Getting started
      • Recording first Macro
    • Objects in VBA
      • Overview
      • Object under project
      • Worksheet object
      • Rows and columns
      • Cell object
      • Range object
      • Properties and range
      • Properties and method
      • Dates
      • Working with color
      • Variables
    • Various boxes and functions in VBA
      • Message box
      • Input box
      • Button
      • If then
      • With .. end with
      • Case
      • For
      • Do loop
      • Logical operator
      • User defined functions
      • Event handling
      • Copy and paste
      • Conventions
      • Array
      • Importing data
      • Calculator
      • CountA function
      • For each loop
      • Password protection
    • Userforms
      • Userform
      • Forms and label
      • Creating a userform
    • More features
      • Text box
      • List box
      • Combobox
      • Checkbox
      • Option button
      • Command button
      • Multipage
      • Image
      • Export and Import
    • Conclusion
      • Conclusion


Course Fee:
USD 10

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations Community

Related Posts:

VBA

 

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top