Developing for Excel with VBA

Focused View

Mike McQuillan

2:38:10

24 View

01 - Course Overview

01 - Course Overview.mp4

01:56

02 - Introducing VBA

02 - Course Overview.mp4

02:36

03 - Introduction.mp4

01:28

04 - What Is VBA-.mp4

03:01

05 - A Brief History of VBA.mp4

01:53

06 - Turning on the Developer Tab.mp4

03:00

07 - Creating a Simple Macro.mp4

03:31

08 - The VBA Editor.mp4

03:44

09 - Basic User Interface.mp4

02:35

10 - Summary.mp4

01:05

03 - Connecting Excel to a Database

11 - Introduction.mp4

01:29

12 - Excel Data Import Capabilities.mp4

02:58

13 - Creating a Database Connection.mp4

04:31

14 - Managing Connections.mp4

01:48

15 - Connecting to a Stored Procedure.mp4

05:36

16 - Macro-enabled Workbooks.mp4

01:04

17 - Creating a Simple Database Search.mp4

04:35

18 - Excel Object Relationships.mp4

01:09

19 - Summary.mp4

01:35

04 - Building a VBA Application in Excel

20 - Introduction.mp4

00:54

21 - Building a Basic User Interface.mp4

02:14

22 - Creating a Named Range for Lookups.mp4

06:00

23 - Adding More Lookups.mp4

02:15

24 - Refreshing Lookup Data.mp4

01:37

25 - Adding the Main Database Connection.mp4

02:03

26 - Creating the Search Macro.mp4

06:07

27 - Being Explicit with Option Explicit.mp4

02:58

28 - Summary.mp4

01:26

05 - Enhancing and Debugging a VBA Application

29 - Introduction.mp4

00:38

30 - Simple VBA Debugging.mp4

03:16

31 - Summary.mp4

01:04

32 - Manipulating User Input.mp4

03:27

33 - Validating User Input and Stepping through Code.mp4

06:08

34 - Adding an Excel Formula.mp4

01:49

35 - Calling VBA When Values Change.mp4

03:45

36 - Resolving Background Refresh Issues.mp4

04:50

37 - Styling the Spreadsheet.mp4

02:49

38 - Auto Refreshing Tables.mp4

01:14

39 - Running Code on Startup.mp4

02:46

06 - Sending Data to Different Workbooks with VBA

40 - Introduction.mp4

01:29

41 - Enhancing the Spreadsheet.mp4

01:35

42 - Checking if Files and Folders Exist.mp4

03:27

43 - Form Controls vs. ActiveX Controls.mp4

05:39

44 - Hiding Worksheets.mp4

01:44

45 - Summary.mp4

02:39

46 - Modifying the User Interface.mp4

03:00

47 - Receiving Feedback from the Database.mp4

03:05

48 - Adding References to External Libraries.mp4

01:51

49 - Using Direct Database Connections.mp4

07:01

50 - VBA Error Blocks.mp4

05:28

51 - Inserting Values into a Separate Workbook.mp4

05:25

52 - Merging Ranges.mp4

06:10

53 - Saving an External Workbook.mp4

02:43

Description

You’re an Excel power user. You can filter data and write formulas with the best of them. But can you use VBA? If not, you’re not making the most of Excel! Watch this course and learn how to build custom user applications in Microsoft Excel.

What You'll Learn?

Microsoft Excel. It’s one of the most popular and used applications in the world, especially in business. Most people can use it to manage data and run simple calculations. But did you know Excel has a programming language built into it, and it can do so much more? No? Then this is the course for you! You will learn all about Visual Basic for Applications (VBA), the programming language built directly into Excel. You’ll find out what VBA is and how it became part of the Microsoft Office suite. More importantly, you’ll discover how VBA can be used to create user applications, querying a database to perform searches. You’ll also see how user interfaces can be built using Excel worksheets, and how buttons can be used to call your code. Whilst all this is going on, you’ll learn how to structure and debug your code. Once you’ve built your first application, you’ll discover how to manipulate other Excel workbooks, inserting values and saving the file as a PDF! By the time this course is through, you’ll have an excellent knowledge of Excel VBA programming, and will have all the skills you need to start creating your own custom spreadsheet applications.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel VBA

Excel

Mike McQuillan

Instructor's Courses

Mike is a polyglot architect/developer who loves to mess around with data. He runs a consultancy company in the UK, helping organizations to build better systems and databases. Mike is married and has one daughter and two dogs, Dolly and Bertie. They keep his feet warm when he's working on courses and articles. Mike has written a book on SQL Server and writes regular articles for sqlservercentral.com. He also likes collecting old computers like the Commodore 64 and Sinclair Spectrum. No, he doesn't know why he does that either.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.