Excel VBA Programming for Chemical Engineers

Source: AIChE
  • Course ID:
    ELA118
  • Type:
    eLearning (online) Course
  • Language:
    English
  • Skill Level:
    Intermediate
  • Duration:
    12 hours
  • CEUs:
    1.20
  • PDHs:
    12.00

Share This Post:

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 online 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.

Mac users please note: Lectures 10 and 11 use Excel VBA ‘userforms’ which are not currently functional in Excel for Macs. Please take the course on a PC.

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
Instructor(s): 

David E. Clough

Dr. David Clough has taught applied statistics at the undergraduate and graduate levels to chemical engineering students for the past 20 years.  At the graduate level, his students have included practicing professionals.

Dr. Clough recently retired after a 43-year career on the faculty of Chemical and Biological Engineering at the University of Colorado’s Boulder Campus.  He is still active in the Department in the Emeritus role, including the supervision of research in applied process control.  He teaches several AIChE Academy courses, both in-person and eLearning...Read more

Checkout

Checkout

Do you already own this?

Pricing

Teams (10 or more)

Minimize cost and maximize learning with Train-A-Team.

Learn more

Individuals

AIChE Members $795.00
AIChE Graduate Student Members $397.50
AIChE Undergraduate Student Members $397.50
Non-Members $1095.00
Accrediting Agencies: 

Horizontal Tabs