Need Help?

Contact Us!

For fastest service please enter your question or issue in the text box below. Enter your name and email address so we can reply to your question or concern. Be sure to give us enough info to identify the course or order that you need help with.

You may also call us at: 561-753-0105

Welcome to SunCam

178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes, Charts

By: Kwabena Ofosu, Ph.D., PE, PTOE

Course Documents, Test Previews and other resources above may attempt to open or download Adobe PDF files. Most modern browsers have built-in PDF readers If you have problems opening this file in your browser, check your browser's or computer system's settings. You can also Download a copy of Adobe PDF reader or we can send them as an email attachment. (We cannot email streaming videos at the moment.) Send PDF Files via Email.

Course Objective

This continuing education course is written specifically for professional engineers with the objective of relating to and enhancing the practice of engineering.

Course Description

This is a Spotlight Course of the Week (Expires: 12/14/2018)
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes, Charts

This course is a hands-on, step-by-step, introduction to computer programming for engineers, scientists and business professionals. By the end of this course, participants will gain the knowledge and skills to develop their own creative customized applications to assist them in their analyses, design, computations, and data management, in their fields of specialty. Participants will be able to identify professional situations in which the application of computer programming methods will be of great advantage to their work and their organization.

This course uses screen captures and an easily readable click-by-click narrative, to present fundamental concepts of computer programming to engineers, scientists and business professionals. The programming language used is Visual Basic for Applications (VBA) in Excel, which is readily available in the Microsoft Office package. This course can be mastered by beginners with no programming experience as well as experienced professionals in need of a refresher, or looking to add a new programming language to their skillset.

This course is the fourth of a four-part series on computer programming in Excel Visual Basic for Applications (VBA). In this course the topics, error handling, arrays, dialog boxes, and charts and graphs are presented. Computer Programming in Visual Basic (VBA) — Part 1, Part 2, and Part 3 are not required pre-requisites to this course. It would however be helpful to understand the basic principles of computer programming as well as the fundamentals of the Excel VBA language as presented in Part 1, Part 2 and Part 3 of this series.

Each chapter presents the fundamentals and theory of the topics, with practical examples from real-world situations. The course presents a hands-on mini project in which the concepts and methods learned are applied and discussed in detail.

178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
Philip Taylor
03/05/2018
Verified Buyer
This course, as the previous three in the series, was excellent. The series is a comprehensive look at introductory VBA programming. It is very useful for an engineer who has facility with Excel but has never taken advantage of the capabilities that VBA programming offers. The only area in this course I wish had been more thorough is the process of using the debugging tools - a few step-by-step examples of how to interact with the debugger (Step Into, Step Over, Step Out, etc.) would be helpful.
Was this helpful?
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
12/28/2017
Verified Buyer
Graphing section is weak. No explanation on how to place on a new sheet, at a specific location on an existing sheet, or code for customizing. The With ... End With statement could use some explanation; I assume it is used for purposes other than working with graphs.
Was this helpful?
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
Nick Halbrook
11/18/2017
Verified Buyer
Again as with the three previous parts this is a simple multiple guess test requiring only reading the course document without needing to write any code to generate answers to questions which is a major course failure IMHO as without this tact it is not possible to test one's ability to demonstrate that one has really learned any VBA programming skills. All four parts are OK as regards presenting VBA programming basics and should allow one to generate effective programs. Question languaging in all parts and especially Part 4 made it difficult to puzzle out what was being asked in some questions especially if one is not familiar with VBA and/or programming lingo/jargon.
Was this helpful?
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
Michael Post
09/17/2017
Verified Buyer
This course provided a good explanation of error handling, arrays and dialog boxes. It had a couple of confusing areas in it though: 1) In the first input box example, it stated that Text (type:=2) is the default but it saved the number as a double without a type:=1 argument. If the Application class is left off, does it automatically change the type to match the variable to which it is assigned? This should be clarified. 2) In the msoFileDialogOpen example, why are the filters not set before the dialog box is opened using FileChosen = fd.Show? If that is the line that halts the program until the user clicks "open", how does the filter get set? Also, how does the program continue far enough to change the "open" text on the button without reaching the If-Then statement? This is very confusing and an explanation of the program flow may help to clarify it. 3) In the print example, the item text is overwritten by the price values on the spreadsheet. The column numbers should be incremented by 1 in the second For-Next loop. Thank you.
Was this helpful?
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
W. David Bruce, Ph.D., P.E.
03/01/2017
Verified Buyer
This was a good course, but I found it to be fairly difficult. It would help to have another short example or two specifically dealing with the application of arrays and with outputting the results obtained to an Excel spreadsheet.
Was this helpful?
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
Kevin Hoshstrasser
01/25/2017
Verified Buyer
Thanks for the interesting course, which will serve as my starting point to really delve into VBA. See you in 2 years for my next CE courses.
Was this helpful?
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
Harry Vanpelt
12/13/2016
Verified Buyer
Good review of array use, error handling and charting
Was this helpful?
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
William Randall
11/09/2016
Verified Buyer
The course was locally presented and the examples were very useful and easy to understand.
Was this helpful?
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
Marlin Vrbas
04/16/2016
Verified Buyer
This was pretty good! I have used VBA as a major part of my livelihood for about 20 years, and I find myself using the same tricks over and over. Now I have some new tricks!

Improvement? This course was supposed to be standalone. But the seventh VBA project seems to be based on a project from an earlier course that I did not take. A little bit of inconsistency, but did not detract from the overall quality or my ability to get the continuing ed hours I needed.
Was this helpful?
suspected error in answer choices for question 14
Stan Zajda
02/25/2016
...
Comments about the correct answer to questions have been removed.
Was this helpful?
(no title provided)
anonymous
05/31/2015
Great course on VBA. Extensive examples. A+
Was this helpful?
(no title provided)
anonymous
12/07/2014
very ambiguous for many of the questions
Was this helpful?
 
SAVE 20%
Order the Complete Set of 4 Courses for $95.84!

You Must Use This Button to Get The Savings
Price: $29.95
Special Price Expires: 12/14/2018
Quantity:
This Course Includes FREE Software
Course Code: 100236-04
Course PDH Hours: 4
Engineering Course Approvals
  • This course is accepted for engineering continuing education credit in all states except: Ohio

About Course Approvals

Other Courses by Kwabena Ofosu, Ph.D., PE, PTOE

Course Title Rating Hours Price
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
(4.5) 72 Reviews
4 $29.95
This Course Includes FREE Software
Special Price Offer: expires at midnight on 12/14/2018
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Boxes & Alerts
(4.4) 24 Reviews
4 $29.95
This Course Includes FREE Software
Special Price Offer: expires at midnight on 12/14/2018
177-Programming MS Excel in Visual Basic (VBA). Part 3: Functions, Procedures, and String Variables
(4.8) 17 Reviews
4 $29.95
This Course Includes FREE Software
Special Price Offer: expires at midnight on 12/14/2018