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.
“Coming Soon – Materi Sedang disusun”
BAB 1 – Create a Macro
- Create a Macro
- Swap Values
- Run Code from a Module
- Macro Recorder
- Use Relative References
- FormulaR1C1
- Add a Macro to the Toolbar
- Macro Security
- Protect Macro
BAB 2 – MsgBox
- MsgBox
- MsgBox Function
- InputBox Function
BAB 3 – WorkBook and WorkSheet Object
- WorkBook and WorkSheet Object
- Path and FullName
- Close and Open
- Loop through Books and Sheets
- Sales Calculator
- Files in a Directory
- Import
BAB 4 – Range Object
- Range Object
- CurrentRegion
- Dynamic Range
- Resize
- Entire Rows and Columns
- Offset
- From Active Cell to Last Entry
- Union and Intersect
- Test a Selection
- Possible Football Matches
- Font
- Background Colors
- Areas Collection
- Compare Ranges
BAB 5 – Variables
- Variables
- Option Explicit
- Variable Scope
- Life of Variables
BAB 6 – If Then Statement
- If Then Statement
- Logical Operators
- Select Case
- Tax Rates
- Mod Operator
- Prime Number Checker
- Find Second Highest Value
- Sum by Color
- Delete Blank Cells
BAB 7 – Loop
- Loop
- Loop-through Defined Range
- Loop-through Entire Column
- Do Until Loop
- Step Keyword
- Create a Pattern
- Sort Numbers
- Randomly Sort Data
- Remove Duplicates
- Complex Calculations
- Knapsack Problem
BAB 8 – Macro Errors
- Macro Errors
- Debugging
- Error Handling
- Err Object
- Interrupt a Macro
- Macro Comments
BAB 9 – String Manipulations
- String Manipulations
- Separate Strings
- Reverse Strings
- Convert to Proper Case
- Count Words
BAB 10 – Date & Time
- Date and Time
- Compare Dates and Times
- DateDiff Function
- Weekdays
- Delay a Macro
- Year Occurences
- Task on Schedule
- Sort Birthdays
BAB 11 – Events
- Events
- BeforeDoubleClick Event
- Highlight Active Cell
- Create a Footer Before Printing
- Bills and Coins
- Rolling Average Table
BAB 12 – Array
- Array
- Dynamic Array
- Array Function
- Month Names
- Size of an Array
BAB 13 – Function and Sub
- Function and Sub
- User Defined Function
- Custom Average Function
- Volatile Functions
- ByRef and ByVal
BAB 14 – Application Object
- Application Object
- Status Bar
- Read Data from Text File
- Write Data to Text File
BAB 15 – ActiveX Controls
- ActiveX Controls
- Text Box
- List Box
- Combo Box
- Check Box
- Option Buttons
- Spin Button
- Loan Calculator
BAB 16 – UserForm
- UserForm
- UserForm and Ranges
- Currency Converter
- Progress Indicator
- Multiple List Box Selections
- Multicolumn Combo Box
- Dependent Combo Boxes
- Loop through Controls
- Controls Collection
- UserForm with Multiple Pages
- Interactive UserForm