===== Excel Easy VBA Tutorials ===== [[http://www.excel-easy.com/vba.html|Excel VBA Tutorials]] * [[http://www.excel-easy.com/vba/create-a-macro.html|1. Create a Macro]] * [[http://www.excel-easy.com/vba/examples/swap-values.html|Swap Values]] * [[http://www.excel-easy.com/vba/examples/run-code-from-a-module.html|Run Code from a Module]] * [[http://www.excel-easy.com/vba/msgbox.html|2. Message Box]] * [[http://www.excel-easy.com/vba/examples/inputbox-function.html|Input Box]] * [[http://www.excel-easy.com/vba/workbook-worksheet-object.html|3. Workbook and Worksheet Object]] * [[http://www.excel-easy.com/vba/examples/loop-through-books-sheets.html|Loop through Books and Sheets]] * [[http://www.excel-easy.com/vba/examples/sales-calculator.html|Sales Calculator]] * [[http://www.excel-easy.com/vba/range-object.html|4. Range Object]] :!: * [[http://www.excel-easy.com/vba/examples/currentregion.html|CurrentRegion]] * [[http://www.excel-easy.com/vba/examples/dynamic-range.html|Dynamic Range]] * [[http://www.excel-easy.com/vba/examples/entire-rows-columns.html|Entire Rows and Columns]] * [[http://www.excel-easy.com/vba/examples/offset.html|Offset]] * [[http://www.excel-easy.com/vba/examples/from-active-cell-to-last-entry.html|From Active Cell to Last Entry]] * [[http://www.excel-easy.com/vba/examples/union-intersect.html|Union and Intersect]] * [[http://www.excel-easy.com/vba/examples/test-a-selection.html|Test a Selection]] :-) * [[http://www.excel-easy.com/vba/examples/possible-football-matches.html|Possible Football Matches]] :-) * [[http://www.excel-easy.com/vba/variables.html|5. Variables]] :!: * [[http://www.excel-easy.com/vba/examples/option-explicit.html|Option Explicit]] * [[http://www.excel-easy.com/vba/examples/variable-scope.html|Variable Scope]] * [[http://www.excel-easy.com/vba/examples/life-of-variables.html|Life of Variables]] * [[http://www.excel-easy.com/vba/if-then-statement.html|6. If-Then-Statement]] :!: * [[http://www.excel-easy.com/vba/examples/logical-operators.html|Logical Operators]] :-) * [[http://www.excel-easy.com/vba/examples/select-case.html|Select Case]] * [[http://www.excel-easy.com/vba/examples/tax-rates.html|Tax Rates]] * [[http://www.excel-easy.com/vba/examples/mod-operator.html|Mod Operator]] :-) * [[http://www.excel-easy.com/vba/examples/prime-number-checker.html|Prime Number Checker]] :-) * [[http://www.excel-easy.com/vba/examples/find-second-highest-value.html|Find Second Highest Value]] :-) * [[http://www.excel-easy.com/vba/loop.html|7. Loop]] :!: * [[http://www.excel-easy.com/vba/examples/loop-through-defined-range.html|Loop through Defined Range]] * [[http://www.excel-easy.com/vba/examples/loop-through-entire-column.html|Loop through Entire Column]] * [[http://www.excel-easy.com/vba/examples/do-until-loop.html|Do Until Loop]] * [[http://www.excel-easy.com/vba/examples/step-keyword.html|Step Keyword]] * [[http://www.excel-easy.com/vba/examples/create-a-pattern.html|Create a Pattern]] :-) * [[http://www.excel-easy.com/vba/examples/sort-numbers.html|Sort Numbers]] :-) * [[http://www.excel-easy.com/vba/examples/randomly-sort-data.html|Randomly Sort Data]] * [[http://www.excel-easy.com/vba/examples/remove-duplicates.html|Remove Duplicates]] :-) * [[http://www.excel-easy.com/vba/examples/complex-calculations.html|Complex Calculations]] * [[http://www.excel-easy.com/vba/examples/knapsack-problem.html|Knapsack Problem]] :-) * [[http://www.excel-easy.com/vba/macro-errors.html|8. Macro Errors]] * [[http://www.excel-easy.com/vba/examples/debugging.html|Debugging]] * [[http://www.excel-easy.com/vba/examples/error-handling.html|Error Handling]] * [[http://www.excel-easy.com/vba/examples/err-object.html|Err Object]] * [[http://www.excel-easy.com/vba/string-manipulation.html|9. String Manipulation]] :!: * [[http://www.excel-easy.com/vba/examples/separate-strings.html|Separate Strings]] :-) * [[http://www.excel-easy.com/vba/examples/reverse-strings.html|Reverse Strings]] * [[http://www.excel-easy.com/vba/date-time.html|10. Date and Time]] * [[http://www.excel-easy.com/vba/examples/compare-dates-times.html|Compare Dates and Times]] * [[http://www.excel-easy.com/vba/examples/datediff-function.html|DateDiff Function]] * [[http://www.excel-easy.com/vba/events.html|11. Events]] * [[http://www.excel-easy.com/vba/array.html|12. Array]] :!: * [[http://www.excel-easy.com/vba/examples/dynamic-array.html|Dynamic Array]] * [[http://www.excel-easy.com/vba/examples/array-function.html|Array Function]] * [[http://www.excel-easy.com/vba/examples/month-names.html|Month Names]] :-) * [[http://www.excel-easy.com/vba/examples/size-of-an-array.html|Size of an Array]] * [[http://www.excel-easy.com/vba/function-sub.html|13. Function and Sub]] :!: * [[http://www.excel-easy.com/vba/examples/user-defined-function.html|User Defined Function]] :-) * [[http://www.excel-easy.com/vba/examples/custom-average-function.html|Custom Average Function]] :-) * [[http://www.excel-easy.com/vba/examples/volatile-functions.html|Volatile Functions]] * [[http://www.excel-easy.com/vba/examples/byref-byval.html|ByRef and ByVal]] :-) * [[http://www.excel-easy.com/vba/application-object.html|14. Application Object]] * [[http://www.excel-easy.com/vba/examples/statusbar.html|StatusBar]] * [[http://www.excel-easy.com/vba/examples/read-data-from-text-file.html|Read Data from Text File]] * [[http://www.excel-easy.com/vba/examples/write-data-to-text-file.html|Write Data to Text File]] * [[http://www.excel-easy.com/vba/activex-controls.html|15. ActiveX-Controls]] * [[http://www.excel-easy.com/vba/userform.html|16. Userform]]