When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Udemy logo

Excel 2007 VBA

Power up your workbooks with Visual Basic for Applications automation

     
  • 4.4
  •  |
  • Reviews ( 22 )
₹799

This Course Includes

  • iconudemy
  • icon4.4 (22 reviews )
  • icon4 total hours
  • iconenglish
  • iconOnline - Self Paced
  • iconcourse
  • iconUdemy

About Excel 2007 VBA

This course introduces you to Excel macro programming using Microsoft's Visual Basic for Application (VBA). The overall focus of this course is to teach you proper Visual Basic programming techniques along with an understanding of Excel's object structure. Other topics in this course include; recording macros, programming basics, proper variable declaration, Visual Basic functions, control structure use, looping, and Userform creation. The final section deals with the debugging tools included in the Microsoft VBA editor and methods on how to effectively use them.

What You Will Learn?

  • Understand the object model.
  • Create, edit and run recorded macros.
  • Understand the Visual Basic editor.
  • Understand programming basics.
  • Use Visual Basic functions.
  • Create and use cotnrol structures.
  • Create, use and edit UserForms.
  • Debug macros and trap for errors.