Teaching WIKI
- teawiki.net -

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
===== 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]]