If you know your way around Microsoft Excel and you鈥檙e ready to learn Visual Basic for Applications (VBA) Programming this course is for you. Join chemical engineer and VBA expert David Clough for an intensive, hands-on introduction to 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.
The basics of Excel VBA programming
In one day, you鈥檒l learn how to improve your efficiency and enhance your spreadsheets by incorporating VBA. You鈥檒l discover how to create time-saving shortcuts via VBA macros and to develop user-defined functions to package custom chemical engineering calculations. You鈥檒l also learn how to manage information between the spreadsheet and VBA environments. And, you鈥檒l see how to design and implement interfaces including user forms and communication with other software packages, such as process simulators. Throughout the day, you鈥檒l cover dozens of topics 鈥� everything from creating Excel add-ins to user interfaces 鈥� that will improve your Excel problem-solving skills immediately.
Be sure to bring your own computer with Excel installed 鈥� preferably the latest version 鈥揳nd get ready to roll up your sleeves to learn by doing.
Mac users please note: A good portion of the afternoon of the course covers Excel VBA 鈥榰serforms鈥� which are not currently functional in Excel for Macs. Please take the course on a PC.
Save $795 or more when you take both this course and CH764 Spreadsheet Problem-Solving for 91成人短视频 Engineers by registering for CH768 Spreadsheet Problem Solving and VBA Programming Combo Course.
Learning Outcomes:
-
Create time-saving VBA macros that streamline your use of Excel.
-
Develop user-defined functions for typical engineering calculations and package families of functions in Excel Add-ins.
-
Exchange data and information between the Excel spreadsheet and the VBA programming environment.
-
Create VBA applications from Excel spreadsheet prototype calculations.
-
Develop user interfaces with VBA鈥檚 message boxes, input boxes, and user forms.
Who Should Attend:
Engineers or scientist who have been working with Excel for some time, have basic spreadsheet skills and basic knowledge of computer programming or have attended AIChE鈥檚 Spreadsheet Problem-Solving for 91成人短视频 Engineers (CH765).
Day One
Registration-7:30 鈥� 8:00
路 Getting Started with VBA
o Configuring Excel for VBA programming
o The Visual Basic Editor (VBE) environment
o Recording and editing macros
o VBE debugging tools
路 User-Defined Functions
o Programming user-defined functions (UDFs)
o Including programming structure in UDFs
o Developing array functions and borrowing Excel functions
o Packaging collections of functions in an Excel add-in
Delving into VBA Programming
路 Communicating with Excel 鈥� object-oriented concepts
路 Data types and scope
路 VBA programming structures
路 Modular organization of VBA programs
User Interfaces and VBA Applications
路 Message boxes, input boxes and on-sheet buttons
路 Programming event handlers
路 UserForms
路 Integration course concepts into an Excel VBA application
路 Interfacing with outside programs
Times displayed are in EST. Please email questions to academy@aiche.org
10:00 鈥� 11:30 Session 1
Getting Started with VBA
- Configuring Excel for VBA programming
- The Visual Basic Editor environment
- Recording and editing macros
- Debugging in the Visual Basic Editor
12:00 鈥� 1:30 Session 2
User-Defined Functions
- Programming user-defined functions (UDFs)
- Including programming structure in UDFs
- Borrowing Excel spreadsheet-based functions
- Developing array functions
- Packaging collections of functions in an Excel add-in
2:30 鈥� 4:00 Session 3
Delving into VBA Programming
- Communicating with the spreadsheet
- Object-oriented concepts
- Data types and scope
- VBA programming structures
- Modular organization of VBA programs
4:30 鈥� 6:00 Session 4
User Interfaces and VBA Applications
- Message boxes, input boxes and on-sheet buttons
- Programming event handlers
- Designing and creating userforms
- Integrating course concepts into an Excel VBA application
- Interfacing with external programs
Day One
Registration-7:30 鈥� 8:00
路 Getting Started with VBA
o Configuring Excel for VBA programming
o The Visual Basic Editor (VBE) environment
o Recording and editing macros
o VBE debugging tools
路 User-Defined Functions
o Programming user-defined functions (UDFs)
o Including programming structure in UDFs
o Developing array functions and borrowing Excel functions
o Packaging collections of functions in an Excel add-in
Delving into VBA Programming
路 Communicating with Excel 鈥� object-oriented concepts
路 Data types and scope
路 VBA programming structures
路 Modular organization of VBA programs
User Interfaces and VBA Applications
路 Message boxes, input boxes and on-sheet buttons
路 Programming event handlers
路 UserForms
路 Integration course concepts into an Excel VBA application
路 Interfacing with outside programs
A laptop with Excel installed (preferably the latest version) is required for this course.
Find answers to questions about registration and refunds, tuition and fees, travel and lodging (for location-based courses), how eLearning courses work, how credits work, and more.
Explore More Areas of Advancement
AIChE Practice+ provides learners with opportunities to work on real-world challenges through industry internships and competitions.
With AIChE Career Discovery庐, we'll help you to identify aptitudes and skills you鈥檒l need in order to achieve your full potential at various career stages.
AIChE Credential validates your proficiency with potential employers in areas such as process intensification, safety, sustainability and others.