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 - The Dictionary class is similar to the Collection class in that it allows you to store a custom collection of objects. This video teaches you how to use dictionaries, including how to reference the Scripting Runtime Object Library, how to create a new Dictionary and add, remove, count and reference the items in it. You'll also learn about the Items and Keys arrays contained within a Dictionary and how to loop over these arrays in order to process all of the items that the Dictionary contains.
Course Index
- Getting Started in the VB Editor
- Writing Your First VBA Macro
- What to do When Things Go Wrong (Errors and Debugging)
- Buttons, Toolbars and Keyboard Shortcuts
- Selecting Cells (Range, Cells, Activecell, End, Offset)
- Worksheets, Charts and Sheets
- Workbooks
- Variables
- Object Variables
- Message Boxes
- Input Boxes
- Application.InputBox
- With Statements
- If Statements
- Select Case Statements
- Do Until and Do While Loops
- Find and FindNext
- For Next Loops
- For Each Loops
- Creating Functions
- Error Handling (On Error, Resume, GoTo)
- Event Procedures
- Application Events
- User Forms
- Files and Folders (FileSystemObjects)
- Text Files (FileSystemObjects)
- File Dialogs
- Arrays
- Constants and Enumerations (Const, Enum)
- Creating Word Documents
- Creating and Updating Linked Word Tables
- Creating PowerPoint Presentations
- Creating Outlook Emails
- ADO (ActiveX Data Objects) Querying a Database
- ADO (ActiveX Data Objects) Modifying Data with Recordsets
- ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE)
- Creating Add Ins
- Type Declarations (UserDefined Types)
- Class Modules
- Using Class Modules in Other Projects
- Custom Collections
- Typed Collections
- Dictionaries
- Disabling Screen Updates
- Saving as a PDF
- Data Labels in Scatter Charts
- ByRef and ByVal
- ByRef and ByVal (When to use Parentheses)
- Making Excel Talk
- Finding the Last Used Row, Column and Cell
- Querying Web Pages using Query Tables
- Browsing to Websites and Scraping a Web Page
- Web Scraping Across Multiple Pages
- Downloading Files from Websites
- Introduction to Charts in VBA
- Embedding Charts in Worksheets
- Introduction to Pivot Tables in VBA
- Pivot Tables using an Access Database
- Pivot Tables using a SQL Server Database
- Pivot Tables and Consolidation Ranges
- PowerPivot Data Models
- Pivot Charts
- Pivot Table Slicers
- Pivot Table Date Fields and Timelines
- Introduction to Shapes
- Formatting Shapes
- Adding Text to Shapes
- Working with Strings
- Splitting Strings
- The Join Function and Concatenating Strings
- Replacing Strings
- Converting the Case of Text
- The Asc and Chr Functions
- The IIf Function
- The Switch Function
- 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!