Visual Basic for Applications: Excel VBA intermediate
Technology:
Expertise:
- 1 Course | 1h 55m 9s
- 5 Books | 51h 55m
- 1 Course | 1h 22m 16s
- 4 Books | 39h 25m
- 1 Course | 1h 57m 23s
- 4 Books | 52h 8m
- Includes Lab
Explore Visual Basic for Applications (VBA), an event-driven programming language created by Microsoft that is mostly used in Microsoft Office applications.
GETTING STARTED
VBA: Building User Interfaces with Forms in VBA & Excel
-
2m 8s
-
10m 28s
GETTING STARTED
VBA: Leveraging VBA to Work with Charts, Stocks, & MS Access
-
2m 56s
-
12m 28s
COURSES INCLUDED
VBA: Getting Started with VBA in Excel
Excel's VBA can be a powerful tool useful for a multitude of purposes if you know how to leverage its capabilities, debug issues, and mitigate for specific limitations. In this introductory course, you'll begin by using subroutines in VBA to perform operations. You'll then define functions and reference and edit cell ranges and Excel sheets with VBA. After that, you'll invoke subroutines with relative cell references, record macros in Excel, and debug macros in VBA. You'll insert columns and sheets from VBA and format cells based on a condition in VBA both manually and using a FormatConditions object. Finally, you'll illustrate how clearing formatting using a FormatConditions object will only clear formatting created using a FormatConditions object, not by using if-else conditionals.
13 videos |
1h 55m
Assessment
Badge
COURSES INCLUDED
VBA: Building User Interfaces with Forms in VBA & Excel
One of the many capabilities of Excel's VBA is building complex user interfaces within Excel. Part of this is the creation of complex forms for gathering input data. In this course, you'll learn how to create user forms using VBA in Excel and, in doing so, achieve user interfaces with complex controls like combo boxes and spinners. You'll also learn how to send emails from VBA while being mindful of security risks and the configuration required if the email provider is Gmail. You'll learn how to validate form input data, insert it into an Excel spreadsheet, and illustrate how such user input can be accepted using complex controls, such as radio buttons and checkboxes, and buttons that, when clicked, trigger the invocation of VBA subroutines.
10 videos |
1h 22m
Assessment
Badge
COURSES INCLUDED
VBA: Leveraging VBA to Work with Charts, Stocks, & MS Access
Leveraging VBA with Excel has many useful capabilities, including the creation and management of pivot tables and charts, and the automation of tasks in MS Access, the lightweight relational database. In this course, you'll learn how to create and edit pivot tables and different chart types, such as bar charts and line charts, using VBA in Excel. You'll then save these Excel charts as images, again using VBA. Next, you'll use Excel's stock datatype to access financial data. Moving on, you'll learn how to use VBA to automate tasks in MS Access, accept user input, validate it, and insert it into an MS Access database. You'll also learn how to run simple SQL queries against that database. Finally, you'll set up event handlers in Excel using VBA and illustrate their purpose.
14 videos |
1h 57m
Assessment
Badge
EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.BOOKS INCLUDED
Book
Microsoft Excel 2019 Programming by Example with VBA, XML, and ASPA practical, how-to book on Excel programming, suitable for readers already proficient with the Excel user interface (UI). If you are looking to automate Excel routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises.
14h 9m
By Julitta Korol
Book
Mastering VBA for Microsoft Office 365, 2019 EditionWritten in clear terms and understandable language, this comprehensive book offers an accessible guide that shows how to extend the capabilities of Office 365 applications with VBA programming.
17h 53m
By Richard Mansfield
Book
Excel VBA Programming for Dummies, 5th EditionWith friendly advice and step-by-step instructions, this easy-to-follow book introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor.
5h 8m
By John Walkenbach, Michael Alexander
Book
Excel VBA in Easy Steps, 2nd EditionWith complete example programs and illustrative screenshots, this book will provide you with a sound understanding of Visual Basic for Applications so you'll be able to write your own VBA programs that can be executed in the Microsoft Excel Office application.
2h 15m
By Mike McGrath
Book
Programming Excel with VBA: A Practical Real-World GuideUsing step-by-step guidance, example applications, and screenshots, this complete guide will teach you how to harness the power of Visual Basic for Applications (VBA) in Microsoft Excel to develop interesting, useful, and interactive Excel applications.
12h 30m
By Flavio Morgado
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Microsoft Excel 2019 Programming by Example with VBA, XML, and ASPA practical, how-to book on Excel programming, suitable for readers already proficient with the Excel user interface (UI). If you are looking to automate Excel routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises.
14h 9m
By Julitta Korol
Book
Mastering VBA for Microsoft Office 365, 2019 EditionWritten in clear terms and understandable language, this comprehensive book offers an accessible guide that shows how to extend the capabilities of Office 365 applications with VBA programming.
17h 53m
By Richard Mansfield
Book
Excel VBA Programming for Dummies, 5th EditionWith friendly advice and step-by-step instructions, this easy-to-follow book introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor.
5h 8m
By John Walkenbach, Michael Alexander
Book
Excel VBA in Easy Steps, 2nd EditionWith complete example programs and illustrative screenshots, this book will provide you with a sound understanding of Visual Basic for Applications so you'll be able to write your own VBA programs that can be executed in the Microsoft Excel Office application.
2h 15m
By Mike McGrath
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Microsoft Excel 2019 Programming by Example with VBA, XML, and ASPA practical, how-to book on Excel programming, suitable for readers already proficient with the Excel user interface (UI). If you are looking to automate Excel routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises.
14h 9m
By Julitta Korol
Book
Mastering VBA for Microsoft Office 365, 2019 EditionWritten in clear terms and understandable language, this comprehensive book offers an accessible guide that shows how to extend the capabilities of Office 365 applications with VBA programming.
17h 53m
By Richard Mansfield
Book
MS Access 2019 Programming by Example: With VBA, XML, and ASPIf you are looking to automate Access routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises.
14h 58m
By Julitta Korol
Book
Excel VBA Programming for Dummies, 5th EditionWith friendly advice and step-by-step instructions, this easy-to-follow book introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor.
5h 8m
By John Walkenbach, Michael Alexander
SHOW MORE
FREE ACCESS
YOU MIGHT ALSO LIKE
Channel
Wintellect C Programming
Channel
Visual Studio
