Writing Your First VBA Macro 
Writing Your First VBA Macro
by WiseOwl
Video Lecture 2 of 76
Not yet rated
Views: 653
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 www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould

www.wiseowl.co.uk - VBA, or Visual Basic for Applications, is a powerful tool that you can use to automate Microsoft Excel. This video introduces you to the basics of writing code in the VB Editor, including how to create a new module, how to write a subroutine, some best practice guidelines for laying out your code and adding comments, and how to write simple VBA instructions. We'll also show you how to run the simple procedure that you'll write, and how to ensure that you can save your code and reopen the file which contains it.

You can see written versions of our Excel VBA tutorials online at:

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)