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.

Important: We sent a receipt email to the address provided. If you do not receive that email, we did not receive your message.

Welcome to SunCam

SunCam: Online Continuing Education Classes

175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction

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

175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction

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 first of a four-part series. A general overview of computers and computer programming languages is presented. A tour of the Excel VBA programming environment follows. The concept of variables is presented as it specifically relates to the VBA programming language.

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.

175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Douglas Durden
06/05/2018
The course provides a very good introduction to VBA programming. The exercises were adequately challenging and instructive. The test reflected the material covered in the course and was fair.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
David Penner
05/28/2018
Verified Buyer
I would give it 4 1/2 stars. My only problem was the GRAND TOTAL command button on the 2nd example project didn't work as it should because the grand total would reset to zero when the Grand Total button subroutine ran. I spent considerable time trying to understand why, but couldn't. Otherwise I was very happy with the course and found it easy to follow.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Stanley Rich
04/14/2018
Verified Buyer
very well presented, self taught VBA, never had formal course, learned several important facts
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Philip Taylor
01/22/2018
Verified Buyer
Excellent course. The instructions on pp. 66-69 were a little unclear - the example screen shot on p. 66 appears to show a project that the user hasn't created.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Gene Rovak
01/04/2018
Verified Buyer
Very useful information. I've been writing speadsheets for years and had previously written many programs in BASIC but had avoided using VBA all this time. The course lays out the fundamentals in a way to encourage taking advantage of this useful set of tools.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Peter Murphy
12/28/2017
Verified Buyer
Fun way to learn VBA.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Charles English
12/10/2017
Verified Buyer
Very clear introduction to VBA. Right level of complexity and detail.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Nick Halbrook
11/17/2017
Verified Buyer
Test is all multiple guess from course manual text study guide which is to say there is no programming needed to be done to answer any of the questions. Some question terminology not straightforwardly part of/from study guide or part of VBA on line lingo making answers to some questions a bit challenging to puzzle out.
1 of 1 customers found this helpful.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Grant Bowers
11/14/2017
Verified Buyer
An excellent course. The teaching style draws you into the subject matter and makes it real.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
William Henrie
11/04/2017
Verified Buyer
Nice introduction. Looking forward to Part 2
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Gregory Alfsen
09/22/2017
I am new to programming in Visual Basic and this introductory course was very informative and instructive. It was clear and understandable and provided two projects to put into practice what I had learned. I would recommend this class to anyone not familiar with Visual Basic and the language of programming. The version of MS Excel used in the training could be updated. Some project instructions appeared missing; and there were some minor typos in the material.
2 of 2 customers found this helpful.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Michael Post
09/11/2017
Verified Buyer
Provides a very basic intro to computers and programming. (A couple of variables were mis-labeled, however, and used int... instead of str... for string variables.)
1 of 1 customers found this helpful.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Oliver Clemons
08/21/2017
Verified Buyer
Very good introduction to Visual Basic in Excel
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
J. Mullis
07/19/2017
Verified Buyer
Good starter for learning VBA. Helps if you are familiar with Excel and have used various versions, easier to navigate to the menus, etc. I found the course easy to follow.
1 of 1 customers found this helpful.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Thom Ferguson
05/07/2017
Verified Buyer
Good course with useful programming drills.
1 of 1 customers found this helpful.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Bill Putney
03/19/2017
Verified Buyer
Information was presented very well. It was a new subject to me, and I was able to understand and learn.
1 of 1 customers found this helpful.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
R Roberts
02/27/2017
Verified Buyer
Overall, a very good inexpensive online course. The free software was a nice bonus. The examples were very good. I do feel that there was 1 question that was a little ambiguous. I missed #11, but felt the question wording was not quite clear. I was looking for form ex's instead of control ex's. I did not find the course literature clarified this well. The one T-F question should not have 'c. none of the above' as a choice. It caused me to spend more time on it than the question justified.
3 of 3 customers found this helpful.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Ronald Duran
02/27/2017
Verified Buyer
Extremely theoretical. We engineers for sure require a much more practical approach for teaching and learning.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Carlos Varela
02/19/2017
Verified Buyer
Allows a beginner to feel comfortable with VBA programming very quickly. Well written and to the point.
2 of 2 customers found this helpful.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Pedro Alberto Saenz-Tabares
02/12/2017
Verified Buyer
I learned a lot, This is a very good course.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
John B. Martin
02/08/2017
Verified Buyer
Difficult for a beginner.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Chris Swenson
02/04/2017
Verified Buyer
I really enjoyed this, and I'm looking forward to the subsequent modules. Very good introduction to to Visual Basic!
2 of 2 customers found this helpful.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Tom Lyons
02/04/2017
Verified Buyer
Excellent course. Very good examples, and a step by step method of how to program
1 of 1 customers found this helpful.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Brian W. Braudaway
01/18/2017
Verified Buyer
Straightforward, accurate and thorough.
1 of 1 customers found this helpful.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Douglas Posey
12/15/2016
Verified Buyer
In reading this review please consider that I am 70 years old and haven't done any programming since the mid 1970's. I thought this was a very good course but it was a little hard for me to follow as an online course. I had to keep going back and forth and this would have been much easier in a book format. It would be good to have all of the programming commands used in the course listed in one place so that when I needed to look one up I could go to one place rather than having to search through many pages for the example of where it was used. I did gain an understanding of visual basic programming and will try the second course.
3 of 3 customers found this helpful.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Doug Sinclair
12/15/2016
Verified Buyer
The topic was covered and complete.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Steve Maley
12/08/2016
Verified Buyer
I've tried for years to learn VBA from books. I've been able to get forms to work, but mostly by trial and error with little understanding. Following this course step-by-step helped me understand userform controls & values, which I have never found to be intuitive.
2 of 2 customers found this helpful.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Harry Vanpelt
12/06/2016
Verified Buyer
I had no previous experience with VBA. The course was easy to understand and the examples were very helpful.
2 of 2 customers found this helpful.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
ronnie
10/29/2016
Verified Buyer
the course need to be more clear and hard to understand. needs more examples and illustrations.
1 of 1 customers found this helpful.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Jeff Huisingh
10/27/2016
Verified Buyer
This was a very helpful introduction to VBA. You included many good fundamentals for a beginner like I am. As with any Office application, I have a strong sense that there is far more to this topic than I can imagine. Thank you!
2 of 2 customers found this helpful.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA) Part 1
David McAnaney
09/12/2016
Verified Buyer
Dr. Ofosu hit a home run with this course, providing the hands-on, step-by-step training that suits us engineers perfectly. He avoids all the jargon that presumes you already know the subject beforehand. I am truly grateful because my computer programming experience is decades old and significantly out-of-date. Thank you.
2 of 2 customers found this helpful.
Was this helpful?
MS Excel VB Part 1
Jason Buda, PE
06/13/2016
Course provides great reference material and give you a good foundation in which to build on going forward to Dr. Ofosu's other sections. I would recommend this as well as his others!
1 of 1 customers found this helpful.
Was this helpful?
VBA an introduction to programming in Visual Basic
Mike Ranieri
05/20/2016
Verified Buyer
This was a good course. It took me 7 hours to take. I did all of the examples and had to debug some code that had some typos in. It is a good introduction. I plan on taking the other 3 courses to maybe help me with my panel schedule spreadsheet.
1 of 1 customers found this helpful.
Was this helpful?
Excellent Introduction
Paul Dorvel
05/06/2016
Verified Buyer
This was a well organized course trending from basics to measured details with clear explanations and user-engaged hands-on VBA coding examples. The only part that threw me off was a statement referring to a "filename" when in fact it should be a "sheet" name. I discovered run-time errors. I look forward to the next course.
1 of 1 customers found this helpful.
Was this helpful?
Excel VBA Programming
George Karageorge
05/05/2016
Very good intro to excel VBA programming. Gives a good summation of what is to be expected.
1 of 1 customers found this helpful.
Was this helpful?
Intro to programming
Anonymous reviewer
04/30/2016
Excellent introduction to programming for beginners.
Was this helpful?
Good Intro to Object-Oriented Programming
Edward Kranz
02/25/2016
Verified Buyer
This was a good first course in object-oriented programming. The concepts were simple for me as I have programmed before. The twist was how simple graphical user interfaces could be integrated with program statements to make something useful quickly.
Was this helpful?
VBA 1 Review
Anonymous reviewer
01/22/2016
Verified Buyer
Good course.

Sorry, but I could not resist "c" for Question 22. You may edit this out
Was this helpful?
Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Anonymous reviewer
12/29/2015
Verified Buyer
First programming course I've taken since Fortran in 1974. Very well thought out and easy to follow. Even if you don't intend to take the rest of the series, this is a great introduction.
1 of 1 customers found this helpful.
Was this helpful?
VB for Excel
Bill H
12/19/2015
Good introduction, well formatted and easy to follow and understand. Reinforces basics and structure of the programming.
Was this helpful?
Programming MS Excel in VBA Part 1
Anonymous reviewer
12/07/2015
Using Excel in a wider context and will eventually take the companion parts.
Was this helpful?
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
Jack Phipps
10/19/2015
A good start. It took a lot longer than four hours to complete the course.
1 of 1 customers found this helpful.
Was this helpful?
(no title provided)
Jeff Simmons
09/05/2015
Verified Buyer
Excellent balance between instruction and applications. Test questions were challenging enough yet covered well in the text.
1 of 1 customers found this helpful.
Was this helpful?
(no title provided)
John Harter
08/11/2015
I found it to be very instructional and of future use, not just an information study. It involves considerable time to fell comfortable in the operations, but worth taking the time to push through it,
Was this helpful?
(no title provided)
anonymous
05/29/2015
Good course for non-programmers.
Was this helpful?
VBA Introduction
Pascal Hayes
03/29/2015
I would have preferred more focus on programming rather than the information on Software/Hardware/etc. But overall, it gave me a good brief on how to get started with VBA - something that I've long wanted to learn more about.
1 of 1 customers found this helpful.
Was this helpful?
(no title provided)
anonymous
03/17/2015
Very easy to follow course and a good introduction to VBA.
1 of 1 customers found this helpful.
Was this helpful?
(no title provided)
anonymous
02/20/2015
Good course.
Was this helpful?
(no title provided)
RAMiller
01/25/2015
This course is an eye-opening event for me. I always questioned why you could not do a do-loop on a spreadsheet. I now know that you can, but you have to do it within VBA.

There are a few typo problems on the course work.

The course has been very helpful and enlightening.
1 of 1 customers found this helpful.
Was this helpful?
(no title provided)
anonymous
12/30/2014
The screen shots in this course were based on Excel for Windows. I have Excel for Mac, so the screen shots were not helpful.
Was this helpful?
(no title provided)
anonymous
12/29/2014
i liked it. and i liked the explanations for right and wrong answers when completed.
1 of 1 customers found this helpful.
Was this helpful?
Intro to VBA feedback
Larry Deaton
12/29/2014
Thank you for preparing the course material. I am interested in learning more about arithmetic manipulation in VBA (I use a lot of Matlab), and this was my first foray into VBA, so I may need to take the follow-on courses.

One issue I had that caused confusion was saving the file & macro. I saved the file as "Record PE Classes.xlsm", which worked for Excel filename, but the spaces presented issues within VBA. Maybe modify your course to cover 'allowed names' before telling us to save the macro.

Also, I toyed around with text boxes, command boxes, etc before getting into the 'save' portion. As a result, I ended up with TextBox53 while your instructions said to save TextBox1. Some mention that the order that the boxes are added is significant would be helpful.

Finally, I never understood how you get the field titles (e.g., 'Name', 'PE#', etc) entered into Excel prior to saving the text box values. I eventually just gave up looking. I assume it was just a command entered at the top of the script instead in the command box region.

overall, it was a good intro and I would recommend it to others.
Was this helpful?
(no title provided)
anonymous
12/26/2014
Good introduction to Excel VBA
Was this helpful?
Great Course
Mike Smith
12/07/2014
Easy to follow.
Was this helpful?
(no title provided)
Derek Rhodes
12/05/2014
This is a great introductory programming course.
Was this helpful?
(no title provided)
anonymous
11/21/2014
The instructions for doing the modules myself weren't completely clear. Since my order for the text boxes was different, I couldn't keep up with the instructor's orders. Some procedures were cut off and couldn't be followed completely. It was clear which examples (if any) we were supposed to open from the downloads. Overall though, very useful for introducing the very basic concepts.
Was this helpful?
VBA
Steve McSpadden, PE
11/18/2014
Excellent course. I learned much about programming and specifically how to manipulate spreadsheets thru Visual Basic commands. This course expanded my technical spreadsheet capability (already respectable for a non-software type) to a much higher level.
Was this helpful?
(no title provided)
Stan Robertson
11/17/2014
I rate the course very highly. The descriptive materials were clear, concise and accurate. I confess to having to spend considerably more than 4 hours to get it done, but it was well worth the time and effort. Thanks for a job well done. Stan Robertson Okla. P.E. 14100
Was this helpful?
Easy to Understand but a Wealth of Details
Bill M
10/23/2014
Understanding VBA has always eluded me even though I craeted macros in Lotus 1-2-3 for many years. This course made VBA easy to understand and has gotten me over the hump so I can now do the programming I have been wanting to do.
Was this helpful?
(no title provided)
DK Brown
10/21/2014
I could have used definitions of the different variables (What's a "Variant"?, etc.) Examples would have been useful.
Was this helpful?
(no title provided)
anonymous
09/29/2014
Good intro course. I would like to see examples/exercises on manipulating information already on a work sheet versus creating a GUI to input data that is written to a spreadsheet.
Was this helpful?
(no title provided)
Bronz Young
08/26/2014
good introduction
Was this helpful?
(no title provided)
anonymous
08/01/2014
course took much more than 4 hours to complete, created example Excel VBA as I when through the course but this was very time comsuming and tedious. Overall this course was very good introduction and gave good starting knowledge in VBA programming. If I can make the time will continue with follow up courses.
Was this helpful?
VBA Part 1 Introduction
W. David Bruce
07/15/2014
I have had three VBA courses over the span of approximately ten years, and this is the best one that I have had so far. The material is straightforward but not trivial. It is a course that I can recommend to anyone who is interested in VBA programming. My specific interest, other than PDH, was to have a good review of VBA programming basics.
Was this helpful?
(no title provided)
John Flory
04/09/2014
Plain language and easy to follow.

Practical in many engineering fields.
Was this helpful?
(no title provided)
anonymous
04/03/2014
I found this course to be very helpful! The clear and concise information was presented in a logical manner and the specific examples made this training very worthwhile.
Was this helpful?
Excel VBA course
anonymous
02/26/2014
Overall, I was happy with the course. The Excel that I used did not match the version in the course, but I managed to get through it. I was always interested to know how to use Visual Basic and now I can see how many of these features are transferred to other software packages such as HMI systems where I do a large amount of programming.

Thank you,

John Guitas
Was this helpful?
(no title provided)
anonymous
02/23/2014
very complete introduction. Slightly confusing to programmers that just start when the "window"opens.
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-01
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
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
(4.8) 29 Reviews
4 $29.95
Special Price Offer: expires at midnight on 7/20/2018
287-Engineering Methods in Microsoft Excel - Part 2: Applied Optimization
No reviews yet.
5 $35.95
Special Price Offer: expires at midnight on 7/20/2018
288-Engineering Methods in Microsoft Excel - Part 3: Data Analysis
(4.8) 4 Reviews
7 $47.95
Special Price Offer: expires at midnight on 7/20/2018




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.

Important: We sent a receipt email to the address provided. If you do not receive that email, we did not receive your message.