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

Thank you. Your message has been sent. We will answer within one business day.

Welcome to SunCam

SunCam: Online Continuing Education Classes

176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Boxes & Alerts

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

If you are having problems opening or downloading the PDF files above, 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

176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Boxes & Alerts

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 second of a four-part series. In this course the topics, conditional statements, message boxes and alerts, and looping structures are presented. Computer Programming in Visual Basic (VBA) — Part 1 is not required as a pre-requisite 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 of this series.

Each chapter presents the fundamentals and theory of the topics, with practical examples from real-world situations. The course presents two hands-on mini projects in which the concepts and methods learned are applied and discussed in detail. The examples and mini projects cover fields from engineering, project management, business, and government.

176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
Philip Taylor
02/16/2018
Excellent course. The following errata were noted: (1) Missing code line on p. 50/95 – need before End If: Else UserForm1.TextBox2. = “SPEED HUMPS NOT APPROVED” ------------------------------ (2) Help from the web: “To run a workbook without triggering a startup macro, you need to open it from within Excel, rather than double-clicking the file in Windows. Open Excel, go to the File menu, click "Open" and locate your file. Hold down the "Shift" key while you click "Open," and continue holding it until the workbook finishes loading. [Or find file under “Recent”, hold down the “Shift” key, and click on file.]” Note: The instruction on p. 61/95 of the course document is incorrect compared to the above: “If it ever becomes necessary to activate the Excel background for example to update some codes, perform the following: Save and close out of Excel. Open the folder containing the file Hold down the Shift key Double click on the file to open it The full Excel view is opened.” ---------------------------- (3) On p. 83/95, “The number of records is known from the spreadsheet as 15,332.” This should read “…15,532” to match the value in the tutorial for Project 4. The value in the code should be changed accordingly.
Was this helpful?
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
Charles English
12/16/2017
Verified Buyer
Useful content and clear presentation. Good use of examples.
1 of 1 customers found this helpful.
Was this helpful?
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
Nick Halbrook
11/17/2017
Verified Buyer
As with Part 1 test is simply multiple guess with no programming needed to be done to develop answers.
1 of 1 customers found this helpful.
Was this helpful?
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
Michael Post
09/11/2017
Verified Buyer
These modules are a perfect size. (Some companies require hundreds of pages to be read for 4 credits and it is rather ridiculous.) The "Shift-Break" discussion provided an excellent way to break out of infinite loops. I'm glad you included that!
1 of 1 customers found this helpful.
Was this helpful?
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
Ramon Santo-Tomas
02/21/2017
Verified Buyer
Excellent course, enjoyed part II as much as I enjoyed Part I...
1 of 1 customers found this helpful.
Was this helpful?
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
Brian W. Braudaway
02/15/2017
Verified Buyer
Good application and interesting Problems. Some experience with VBA would go a long way in making this course worthwhile.
1 of 1 customers found this helpful.
Was this helpful?
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
Tom Lyons
02/04/2017
Verified Buyer
Excellent course. Very good examples and screen shots to allow you to follow along
1 of 1 customers found this helpful.
Was this helpful?
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
Douglas Posey
12/17/2016
Verified Buyer
Very good course but much more difficult than I expected. For me this is a course that I would be able to get a lot more from in a setting where there was an instructor to answer questions. I have a basic understanding of the material but could not create a useful program.
1 of 1 customers found this helpful.
Was this helpful?
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
Harry Vanpelt
12/07/2016
Verified Buyer
The course was well structured and the examples were easily followed.
Was this helpful?
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
William Randall
11/04/2016
Verified Buyer
The course was very instructive, but I expected that the examples would not have been worked to completion at the time that I downloaded them. For examples, if the worksheets had been filled in, but the macros had not yet been written, I would have found it more useful.
Was this helpful?
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
Raymond Ware
10/16/2016
Verified Buyer
Interesting course for someone who has not done any programming since college. Basic course with good examples.
Was this helpful?
Pretty Good
Anonymous reviewer
04/30/2016
Could use more tables to help explain programming options.
Was this helpful?
Visual Basic Part 2 project
Tom Tilsner
04/08/2016
Verified Buyer
I could not figure out how to create the dashboard. The instructions do not say which functions it is comprised of.
I could not test the Florida Bridges program because I could not get a copy of the spreadsheet with 15332 records. I'd prefer exercises that do not require loading large files.
Was this helpful?
Programming MS Excel in VBA, Part 2
Walter David Bruce, Ph.D., P.E.
01/02/2016
This was an excellent course. Even though I have had VBA training and some experience in VBA programming, this course helped me to review the material in an effective manner. The examples were clear and easy to follow.
Was this helpful?
Makes Sense
Bill H
12/26/2015
This course covers some of the standard functionalities of VBA and provides incentives and hints into how to make your Excel spreadsheets more foolproof.
Was this helpful?
(no title provided)
04/17/2015
Good course.
Was this helpful?
(no title provided)
anonymous
01/29/2015
Just the right amount of material.
Was this helpful?
Takes 12 hours to perfect it for 4 PDH?
anonymous
12/28/2014
I think you can pass exam in four hours but to perfect or mastery of the complete course to get A will take 12+ hours. I did pass in first attempt after 4 hours scoring a B but did actually did two exercises including finding how to get Developer on my Excel by using Google as normal set up does not show Developer on program. The course marketing should tell such things are needed
1 of 1 customers found this helpful.
Was this helpful?
(no title provided)
Richard Sita
03/08/2014
Test Question #2 doesn't appear to have any valid answers

In the Looping portion, I was surprised to see the lengthy series if If,ElsIf statements to look up the county code... so much error-prone typing. Wouldn't a better method be to set up a loop to search a look up table as follows:

'look for a match on the county code

j = 1

n = 999999

err = 0

Do While intCntyCode n

n = Sheets("bridges").Cells(j, 3).Value

j = j + 1



'break if we don't find a match

If Sheets("bridges").Cells(j, 3).Value = "" Then

err = 1

Exit Do

End If

Loop



If err = 1 Then

Cells(i, 2).Value = "County Code Not Found"

Else

Cells(i, 2).Value = Sheets("bridges").Cells(j, 1).Value

End If

Was this helpful?
(no title provided)
anonymous
02/25/2014
A very nice next step from 175. This is beginning to make VBA truly useful.
Was this helpful?
 
SAVE 20%
Order the Complete Set of 4 Courses for $288.00!

You Must Use This Button to Get The Savings
Price: $90.00
Quantity:
This Course Includes FREE Software
Course Code: 100236-02
Course PDH Hours: 4
Engineering Course Approvals
  • This course is accepted for engineering continuing education credit in all states.

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) 66 Reviews
4 $90.00
This Course Includes FREE Software
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
(4.7) 25 Reviews
4 $29.95
Special Price Offer: expires at midnight on 4/27/2018
287-Engineering Methods in Microsoft Excel - Part 2: Applied Optimization
No reviews yet.
5 $35.95
Special Price Offer: expires at midnight on 4/27/2018
288-Engineering Methods in Microsoft Excel - Part 3: Data Analysis
(4.7) 3 Reviews
7 $47.95
Special Price Offer: expires at midnight on 4/27/2018