If you know your way around Microsoft Excel and you’re ready to learn Visual Basic for Applications (VBA) Programming this course is for you. In this course chemical engineer and VBA expert David Clough will introduce the built-in programming capabilities of Microsoft Excel, and its companion VBA programming language. Learn how to take your spreadsheet problem-solving skills to the next level.
Topics will include:
- How to work back and forth between Excel and VBA
- Recording and editing macros
- Debugging VBA code
- Developing Excel add-ins
- VBA programming fundamentals and techniques
- Excel user interfaces: message and input boxes and user forms
What you’ll learn:
The basics of Excel VBA programming
Learn how to improve your efficiency and enhance your spreadsheets by incorporating VBA. You’ll discover how to create time-saving shortcuts via VBA macros and to develop user-defined functions to package custom chemical engineering calculations. You’ll also learn how to manage information between the spreadsheet and VBA environments. And, you’ll see how to design and implement interfaces including user forms and communication with other software packages, such as process simulators. Throughout the day, you’ll cover dozens of topics – everything from creating Excel add-ins to user interfaces – that will improve your Excel problem-solving skills immediately.
Who should attend
You are an engineer or scientist who has been working with Excel for some time, have basic spreadsheet skills and basic knowledge of computer programming or have taken AIChE’s Spreadsheet Problem-Solving for Chemical Engineers (ELS-101).