Creating Functions 
Creating Functions
by WiseOwl
Video Lecture 20 of 76
Not yet rated
Views: 446
Date Added: May 16, 2017

Lecture Description

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link to make a donation. Thanks for watching!

By Andrew Gould - A VBA function is a procedure that can return a value and this video teaches you how to create them. You'll learn how to declare a function and how to add parameters, including optional parameters and default values. You'll also see several ways to call the functions you've written, including from other VBA procedures and from an Excel worksheet. The video also talks about how to rewrite existing subroutines to replace repetitive code with functions.

Course Index

  1. Getting Started in the VB Editor
  2. Writing Your First VBA Macro
  3. What to do When Things Go Wrong (Errors and Debugging)
  4. Buttons, Toolbars and Keyboard Shortcuts
  5. Selecting Cells (Range, Cells, Activecell, End, Offset)
  6. Worksheets, Charts and Sheets
  7. Workbooks
  8. Variables
  9. Object Variables
  10. Message Boxes
  11. Input Boxes
  12. Application.InputBox
  13. With Statements
  14. If Statements
  15. Select Case Statements
  16. Do Until and Do While Loops
  17. Find and FindNext
  18. For Next Loops
  19. For Each Loops
  20. Creating Functions
  21. Error Handling (On Error, Resume, GoTo)
  22. Event Procedures
  23. Application Events
  24. User Forms
  25. Files and Folders (FileSystemObjects)
  26. Text Files (FileSystemObjects)
  27. File Dialogs
  28. Arrays
  29. Constants and Enumerations (Const, Enum)
  30. Creating Word Documents
  31. Creating and Updating Linked Word Tables
  32. Creating PowerPoint Presentations
  33. Creating Outlook Emails
  34. ADO (ActiveX Data Objects) Querying a Database
  35. ADO (ActiveX Data Objects) Modifying Data with Recordsets
  36. ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE)
  37. Creating Add Ins
  38. Type Declarations (UserDefined Types)
  39. Class Modules
  40. Using Class Modules in Other Projects
  41. Custom Collections
  42. Typed Collections
  43. Dictionaries
  44. Disabling Screen Updates
  45. Saving as a PDF
  46. Data Labels in Scatter Charts
  47. ByRef and ByVal
  48. ByRef and ByVal (When to use Parentheses)
  49. Making Excel Talk
  50. Finding the Last Used Row, Column and Cell
  51. Querying Web Pages using Query Tables
  52. Browsing to Websites and Scraping a Web Page
  53. Web Scraping Across Multiple Pages
  54. Downloading Files from Websites
  55. Introduction to Charts in VBA
  56. Embedding Charts in Worksheets
  57. Introduction to Pivot Tables in VBA
  58. Pivot Tables using an Access Database
  59. Pivot Tables using a SQL Server Database
  60. Pivot Tables and Consolidation Ranges
  61. PowerPivot Data Models
  62. Pivot Charts
  63. Pivot Table Slicers
  64. Pivot Table Date Fields and Timelines
  65. Introduction to Shapes
  66. Formatting Shapes
  67. Adding Text to Shapes
  68. Working with Strings
  69. Splitting Strings
  70. The Join Function and Concatenating Strings
  71. Replacing Strings
  72. Converting the Case of Text
  73. The Asc and Chr Functions
  74. The IIf Function
  75. The Switch Function
  76. Working with Dates

Course Description

Excel VBA is a powerful (and fun!) tool which allows you to automate your Excel workbooks. These videos will help you through your first steps on the way to becoming a programmer in Excel. You don't need any prior programming knowledge as we'll take things from first principles and hopefully give you a flavour of the cool things you can do with a little bit of effort!


There are no comments. Be the first to post one.
  Post comment as a guest user.
Click to login or register:
Your name:
Your email:
(will not appear)
Your comment:
(max. 1000 characters)
Are you human? (Sorry)