|
|
Excel Programming with VBA
|
|
|
|
Short Course Number: CH200
CEU's: 0.75
PDH's: 7.50
Number of days: 1
|
WHAT YOU WILL LEARN:
The purpose of this 1-day, intensive, hands-on course is to get you up to speed quickly in VBA programming and provide you with VBA program examples. If you require the capabilities of the built-in programming language of Microsoft Excel™ and Visual Basic (VBA) then this course is for you. WHO SHOULD ATTEND:
This course is intended for engineers and scientists who have good spreadsheet skills and basic knowledge of computer programming. Those who have previously attended the Institute’s Spreadsheet Power course, or who are already familiar with the expansive capabilities of spreadsheets, will find this course to be an excellent reinforcement. **Laptops are required for this course** YOU CAN EXPECT TO: - Learn how to apply VBA programming to many different engineering and technical applications
- Practice using the Visual Basic Editor to examine VBA code
- Learn how to communicate with the spreadsheet
- Learn specific debugging techniques using the Visual Basic Editor
Excel Programming/Spreadsheet Combo CH203 - This course is a combination of "Spreadsheet Power" (CH201) and "Excel Programming with VBA" (CH200). Take these courses as a combo and save up to $445.00 |
10/14/09 - 10/14/09 Chicago, Illinois
Held At: Chicago Marriott Downtown
|
02/24/10 - 02/24/10 Houston, Texas
Held At: Omni Houston Hotel at Westside
|
05/12/10 - 05/12/10 San Francisco, California
Held At: Hyatt at Fisherman's Wharf
|
|
David E. Clough, PhD, is Professor of Chemical Engineering at the University of Colorado, Boulder. His interests are applied computing in chemical engineering, process control, and applied statistics. He has taught the use of spreadsheets in chemical engineering applications since 1985, and he has won a number of teaching awards.
Miles Julian is retired after 41 years with DuPont and is a consultant in engineering evaluations and methanol technology, both in the United States and in Europe. He has taught AIChE’s course Spreadsheet Power! With David Clough since 1989.
|
|
Getting Started with VBA Recording VBA Macros
Data Types in VBA: VBA Algorithm Structure, Decisions, Loops, and Modular Programming
VBA User Interfaces: Connecting Spreadsheet Objects (buttons, toolbars) to VBA; Using Message and Input Boxes; Custom Interfaces with User Forms; Event Handlers
Using VBA to Connect Excel with Other Applications. Excel/VBA as the User Interface to Fortran and C/C++ Programs; Interconnecting Excel with MathCAD, MATLAB, and HYSYS.
|
ASME Travel Policy: ASME is not responsible for the purchase of non-refundable airline tickets or the cancellation/change fees associated with canceling a flight. Please call to confirm that the course is running before purchasing airline tickets. ASME retains the right to cancel a course up to 3 weeks before scheduled presentation date.
For other FAQs click here
Take advantage of Delta Airlines discount now through September 2009.
Please click here for additional Venue and Hotel information.
|
|
|
|
