Getting Started in the VB Editor 
Getting Started in the VB Editor
by WiseOwl
Video Lecture 1 of 76
Not yet rated
Views: 40
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 - Before you can start writing VBA code for Excel you need to understand how to use the tool that you'll use to do your programming. This video teaches you how to get started using the Visual Basic Editor, including how to get into the application from various versions of Excel, how to work with the various windows, how to modify the default settings and how to work with modules. You won't learn how to write any code here, but this video will ensure your life will be as easy as possible when you do!

You can see written versions of our Excel VBA tutorials online at:
www.wiseowl.co.uk/blog/s161/online-excel-vba-training.htm

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!

Comments

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)