Microsoft VBA Courses Available
This course is an introduction to Visual Basic for Applications using Excel. Macros are automated and edited using Visual Basic. Programming structures and programming principals are introduced at a beginner’s level.
21 hours (3 days). If delegates know Excel to an Advanced level, the course can be completed in 2 days.
This course is intended for a delegate who knows Excel to an advanced level and wants to be able to edit macros with confidence.
The delegates must have a good knowledge of Excel.
Method of training:
Instructor led, hands-on exercises using a computer. Groups not more than 12 delegates.
(If on mobile swipe table left and right to view details)
Topics Revision on Excel Functions, Named Ranges and Pivot Tables Security issues when creating workbooks with macros Personal Macro Wo rkbook Editing/Deleting Macros Understanding Relative and Absolute Macros Assigning Macros to Toolbars or objects or command buttons Understanding the Visual Basic Screen Performing a Macro on The Open Of A Workbook or on the click on a sheet, or an action that took place on a sheet. Show macros icons for a specific workbook only Determining The Last Row of a Range and coping formulae to the last row by using a macro. Coding To Protect/Unprotect Worksheets or Workbooks Using Variables The difference between Input Boxes and Message Boxes Using Userforms as an interface between the user and the program Understanding Private and Public procedures or functions The If Statement The Select Case Statement The For Next Loop Do Loop Debugging a Macro Creating VB Custom Functions Protecting the coding with a password Error Handling in procedures Using Arrays (Introduction) Projects to illustrate the importing of a text file and transferring data between workbooks