Pelatihan VBA for Microsoft Excel

Pelatihan VBA for Microsoft Excel

Pelatihan VBA for Microsoft Excel Microsoft Excel with Visual Basic for Applications incorporates a whole new way of automating applications called Automation. Visual Basic acts as general-purpose language that is independent of the application. Even thought Excel host Visual Basic. Visual Basic does not have any special “hooks” into Excel’s internals. Rather, Excel exposes is capabilities to Visual Basic by mean of a special set of command called an object library. Visual Basic talks to Excel’s object library.

ikuti juga : training public speaking dan presentation skills

MATERI 

1. RECORDING A MACRO
   a.Recording A Macro (To Format Currency) b.Running The Macro c.Assign A Shortcut Key To The Macro d.Looking at The Macro e.Recording Another Macro (To Merge Cells Vertically) f.liminate Innecessary Lines From The Macro
2. EDITING A RECORDED MACRO
   a.Recording A Macro To Remove Gridlines
   b.Run The Macro From The Visual Basic Editor
   c.Toogle The Value Of A Property With A Macro
3. VARIABLES
   a.Statements Used To Declare Variables
   b.User-Defined Types
4. SUB PROCEDURS
   a.Qualities of Sub Procedures
   b.Calling Sub Procedures from The Same Workbook
   c.Calling Sub Procedures from Another Workbook
5. FUNCTION PROCEDURES
   a.Qualities Of Function Procedures
   b.User-Defined Functions
6. USER INPUT
   a.Named Arguments
   b.Msgbox Function
   c.Inputbox Function
   d.Inputbox Method
   e.Using Built-In Microsoft Excel Dialog Boxes
7. CONDITIONAL BRANCHING
   a.If … Then … Else Statement
   b.Select Case Statement LOOPING
   c.Do … Loop Statement
   d.For … Next Statement
8. OBJECT
   a.Properties
   b.Methods
   c.Object Architecture
   d.Referencing Objects
   e.Working With Objects
9. COLLECTIONS
   a.Set Of Related Objects
   b.Important Collections
   c.Add and Close A Workbook
   d.Use Autolist To Learn Constant Values
   e.Declare Variables To Enable Auto Lists
   f.Enhancing Recorded Selections
   g.Simplify Select Groups
   h.Exploring Ranges and Its Property
10. CHART OBJECTS
    a.Record A Macro That Creates A Chart
    b.Modify the Macro That Creates A Chart
    c.Refer To an Existing Embedded Chart
    d.Record A Macro That Modifies Chart
11. HANDLING ERRORS
    a.Error Statements and Functions
    b.Statement atau Function
    c.Creating an error Handler
    d.Setting an Error Trap
    e.Writing an Error-Handling Routine
    f.Exciting the Routine
    g.Other Ways To Handle Errors
12. CREATING THE FORM’S USER INTERFACE
    a.Create The Form
    b.Adding Frame And Option Buttons
    c.Add Check Box And Text Box
    d.Initialise The Text Box
    e.Add Command Buttons
    f.Create A Macro To Switch Views
    g.Dynamically Hide Columns
    h.Implement Option Buttons
    i.Implement A Check Box
    j.Print The Repor

informasi