Library

Course: Learn VBA macros

Learn VBA macros

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
  • Self-Paced
About this Course

A macro is a programming language that runs in MS excel environment. The tool we used to write macros is VBA editor. 

Brief Outline: 

  • High Quality Video Tutorials on Learn VBA macros. 
  • Includes E-books 
  • Includes links to source file 
  • VBA programming 

VBA Editor: The editor is built in MS excel, all you need to install Ms excel (2010 or later). 

Basic knowledge
  • Nothing, as this course is for the beginners. But the knowledge of MS Excel will help you
What you will learn

The following things you will learn through out the course are given below:

  • To automate the repetitive task in the spread sheets either from keyboard or mouse
  • Instead of manually formatting the excel sheet you can use macro to automate that process
  • You can customize and improve the spreadsheets, if you’re willing to code
  • You can use VBA to program macros, build user forms for data entry, import and export data, and automatically update frequently changing data
Curriculum
Number of Lectures: 49
Total Duration: 02:42:58
Cell Referencing
  • Introduction to VBA  

    The resource file is attached with the lecture.

  • Write data in cells  

    The resource file is attached with lecture.

  • Font Styles  

    The resource file is attached with lecture.

  • Font BG Colour  

    The resource file is attached with lecture.

  • Apply border and set alignment  

    The resource file is attached with lecture.

  • Copy & Paste the cell data  

    The resource file is attached with lecture.

  • Wrap and rotate the text  

    The resource file is attached with lecture.

  • Merge and unmerge the cells  

    The resource file is attached with lecture.

  • Clear and delete the cells  

    The resource file is attached with lecture.

  • Add rows and columns  

    The resource file is attached with lecture.

  • Hide unhide rows and columns  

    The resource file is attached with lecture.

  • Adjust height and width  

    The resource file is attached with lecture.

  • Import macro files  

    The resource file is attached with lecture.

Loops & If else statements
  • For loops  

    The resource file is attached with lecture.

  • To display all 56 colours  

    The resource file is attached with lecture.

  • Monitor For loop  

    The resource file is attached with lecture.

  • Do until loop  

    The resource file is attached with lecture.

  • If else statement  

    The resource file is attached with lecture.

  • If And statement  

    The resource file is attached with lecture.

  • If For statement  

    The resource file is attached with lecture.

  • Case statement  

    The resource file is attached with lecture.

  • Message box  

    The resource file is attached with lecture.

  • Count rows and columns  

    The resource file is attached with lecture.

  • Input box  

    The resource file is attached with lecture.

  • 1-D Array  

    The resource file is attached with lecture.

  • 2-D Arrays  

    The resource file is attached with lecture.

User Forms
  • Command Button  

    The resource file is attached with lecture.

  • Save User form  
  • Radio Button  

    The resource file is attached with lecture.

  • Check box  

    The resource file is attached with lecture.

  • Text box  

    The resource file is attached with lecture.

  • Combo box  

    The resource file is attached with lecture.

  • List Box  

    The resource file is attached with lecture.

  • To protect and Unprotect the cells  

    The resource file is attached with lecture.

  • To create a function  

    The resource file is attached with lecture.

  • Events in VBA  

    The resource file is attached with lecture.

Sheet Referencing
  • Add sheets  

    The resource file is attached with lecture.

  • Renaming sheets  

    The resource file is attached with lecture.

  • Copy and move sheets  

    The resource file is attached with lecture.

  • Hide and unhide sheets  

    The resource file is attached with lecture.

  • Protect and unprotect sheet  

    The resource file is attached with lecture.

  • Create workbook  

    The resource file is attached with lecture.

  • Open and close workbook  

    The resource file is attached with lecture.

  • Delete a file  

    The resource file is attached with lecture.

  • Create a folder  

    The resource file is attached with lecture.

Bonus Lectures
  • Apply short cuts to macros  

    The resource file is attached with lecture.

  • Control userform tools  

    The resource file is attached with lecture.

  • Auto update the cells  

    The resource file is attached with lecture.

  • Upload an file  

    The resource file is attached with lecture.

Reviews (0)