Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Hyper-disambiguated Excel VBA Programming

Grant Gamble

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
40 Videos (5h 57m)
    • 1.1. Course introduction

      4:47
    • 1.2. Excel VBA overview

      1:40
    • 1.3. The Developer Tab

      2:52
    • 1.4. Macro security

      5:48
    • 1.5. The Visual Basic Editor and Project Explorer

      2:02
    • 1.6. Excel objects and event code

      7:59
    • 1.7. Writing a macro in the VBE

      3:57
    • 1.8. Using the Immediate window

      3:11
    • 1.9. Saving a macro-enabled workbook

      1:30
    • 1.10. The correct way to use the macro recorder

      12:50
    • 1.11. Analysing a recorded macro

      6:58
    • 1.12. Improving a recorded macro

      11:59
    • 1.13. Assigning a macro to a button

      12:52
    • 1.14. Testing a macro on another worksheet

      5:54
    • 2.1. The Excel Object Model

      12:07
    • 2.2. VBA Classes and Functions

      11:28
    • 2.3. Properties and Methods

      12:54
    • 2.4. Data Variables

      13:27
    • 2.5. Object Variables

      19:25
    • 2.6. Option Explicit

      5:25
    • 2.7. Declaring and Using Constants

      5:49
    • 2.8. Using MsgBox for Output

      10:11
    • 2.9. Using MsgBox for Input

      9:30
    • 2.10. Using VBA InputBox

      6:25
    • 2.11. Using Application MsgBox

      6:19
    • 3.1. If Statements

      11:36
    • 3.2. If ... Else Statements

      13:18
    • 3.3. Select ... Case

      9:19
    • 3.4. For ... Next Loops

      9:32
    • 3.5. For Each ... Next Loops

      6:46
    • 3.6. Do ... While Loops

      13:56
    • 3.7. Do ... Until Loops

      7:27
    • 3.8. Creating Arrays

      10:16
    • 3.9. Dynamic Arrays

      13:25
    • 3.10. Utilizing Arrays

      11:05
    • 4.1. Sub Procedures and Module-level Variables

      10:53
    • 4.2. Static Variables

      5:29
    • 4.3. Passing Parameters

      11:29
    • 4.4. Creatig and Calling Functions

      7:48
    • 4.5. Creating User-defined Functions

      17:04

About This Class

The video tutorials in this course will show you how to automate Microsoft Excel tasks and operations. It is aimed particularly at Excel users, without much programming experience, who struggle to remember the syntax and structure of the VBA programming language. During the course, we will use a style of programming which emphasizes the significance of each line of code that you write. This means that when you revisit the code, the meaning of each line is apparent from the syntax, rather than becoming more and more unfamiliar. The course also demonstrates how to get the maximum benefit from IntelliSense, Microsoft's code completion feature. Whether you are looking to enhance your career prospects, save your company money or increase your productivity, this course will provide your with all the knowledge you need to get started. You can download all of the materials used in the lectures, so that you can follow along. (Please, remember to unZIP the downloaded files.)

2

Students

--

Projects

0

Reviews (0)

Grant Gamble is an experienced IT trainer, developer, consultant and author able to deliver a wide range of training courses. He has a vast experience of delivering public and on-site IT training content at different skill levels, to groups of varying sizes.

His UK company G Com Solutions Limited provide IT training courses and consultancy to a wide range of UK and international clients. His speciality is running week-long, intensive training workshops on topics like Microsoft Power BI...

See full profile