Developing for Excel with VBA
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 is one of the most popular and used applications in the world, especially in business. Most people 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! In this course, Developing for Excel with VBA, you’ll gain the ability to create user applications in Excel using the Visual Basic for Applications language built directly into Excel. First, you’ll explore how to hook Excel up to a database, as well as how to manipulate that data using VBA. Next, you’ll discover how to build a user interface in Excel with VBA. Finally, you’ll learn how to make different Excel spreadsheets communicate with each other, and even how to generate PDFs straight from your Excel files. When you’re finished with this course, you’ll have the skills and knowledge of Excel VBA needed to create comprehensive and useful applications directly inside Excel.
Table of contents
- Introduction 1m
- Simple VBA Debugging 3m
- Manipulating User Input 4m
- Validating User Input and Stepping through Code 6m
- Adding an Excel Formula 2m
- Calling VBA When Values Change 5m
- Updating Values When Cell Values Change 4m
- Styling the Spreadsheet 2m
- Auto Refreshing Tables and Maintaining Formatting 4m
- Running Code on Startup 3m
- Summary 1m
- Introduction 1m
- Enhancing the Spreadsheet 2m
- Modifying the User Interface 3m
- Receiving Feedback from the Database 3m
- Adding References to External Libraries 2m
- Using Direct Database Connections 5m
- VBA Error Blocks 5m
- Inserting Values into a Separate Workbook 6m
- Merging Ranges 6m
- Saving an External Workbook 3m
- Checking if Files and Folders Exist 3m
- Form Controls vs. ActiveX Controls 6m
- Hiding Worksheets 2m
- Summary 3m
About the author
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 doe... more