Level 4

VBA

Level 4 (VBA) membutuhkan keahlian khusus untuk menggunakannya. Tapi, saya akan membuatnya lebih mudah untuk Anda. Harap ikuti instruksi di setiap bagian dari panduan ini.

BAB 1 – Create a Macro

  1. Create a Macro
  2. Swap Values
  3. Run Code from a Module
  4. Macro Recorder
  5. Use Relative References
  6. FormulaR1C1
  7. Add a Macro to the Toolbar
  8. Macro Security
  9. Protect Macro

BAB 2 – MsgBox

  1. MsgBox
  2. MsgBox Function
  3. InputBox Function

BAB 3 – WorkBook and WorkSheet Object

  1. WorkBook and WorkSheet Object
  2. Path and FullName
  3. Close and Open
  4. Loop through Books and Sheets
  5. Sales Calculator
  6. Files in a Directory
  7. Import

BAB 4 – Range Object

  1. Range Object
  2. CurrentRegion
  3. Dynamic Range
  4. Resize
  5. Entire Rows and Columns
  6. Offset
  7. From Active Cell to Last Entry
  8. Union and Intersect
  9. Test a Selection
  10. Possible Football Matches
  11. Font
  12. Background Colors
  13. Areas Collection
  14. Compare Ranges

BAB 5 – Variables

  1. Variables
  2. Option Explicit
  3. Variable Scope
  4. Life of Variables

BAB 6 – If Then Statement

  1. If Then Statement
  2. Logical Operators
  3. Select Case
  4. Tax Rates
  5. Mod Operator
  6. Prime Number Checker
  7. Find Second Highest Value
  8. Sum by Color
  9. Delete Blank Cells

BAB 7 – Loop

  1. Loop
  2. Loop through Defined Range
  3. Loop through Entire Column
  4. Do Until Loop
  5. Step Keyword
  6. Create a Pattern
  7. Sort Numbers
  8. Randomly Sort Data
  9. Remove Duplicates
  10. Complex Calculations
  11. Knapsack Problem

BAB 8 – Macro Errors

  1. Macro Errors
  2. Debugging
  3. Error Handling
  4. Err Object
  5. Interrupt a Macro
  6. Macro Comments

BAB 9 – String Manipulations

  1. String Manipulations
  2. Separate Strings
  3. Reverse Strings
  4. Convert to Proper Case
  5. Count Words

BAB 10 – Date & Time

  1. Date and Time
  2. Compare Dates and Times
  3. DateDiff Function
  4. Weekdays
  5. Delay a Macro
  6. Year Occurences
  7. Task on Schedule
  8. Sort Birthdays

BAB 11 – Events

  1. Events
  2. BeforeDoubleClick Event
  3. Highlight Active Cell
  4. Create a Footer Before Printing
  5. Bills and Coins
  6. Rolling Average Table

BAB 12 – Array

  1. Array
  2. Dynamic Array
  3. Array Function
  4. Month Names
  5. Size of an Array

BAB 13 – Function and Sub

  1. Function and Sub
  2. User Defined Function
  3. Custom Average Function
  4. Volatile Functions
  5. ByRef and ByVal

BAB 14 – Application Object

  1. Application Object
  2. Status Bar
  3. Read Data from Text File
  4. Write Data to Text File

BAB 15 – ActiveX Controls

  1. ActiveX Controls
  2. Text Box
  3. List Box
  4. Combo Box
  5. Check Box
  6. Option Buttons
  7. Spin Button
  8. Loan Calculator

BAB 16 – UserForm

  1. UserForm
  2. UserForm and Ranges
  3. Currency Converter
  4. Progress Indicator
  5. Multiple List Box Selections
  6. Multicolumn Combo Box
  7. Dependent Combo Boxes
  8. Loop through Controls
  9. Controls Collection
  10. UserForm with Multiple Pages
  11. Interactive UserForm