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

177-Programming MS Excel in Visual Basic (VBA). Part 3: Functions, Procedures, and String Variables

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

177-Programming MS Excel in Visual Basic (VBA). Part 3: Functions, Procedures, and String Variables

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 third of a four-part series on computer programming in Excel Visual Basic for Applications (VBA). In this course, topics on functions and procedures, and working with string variables are covered. A tour of the VBA object library is also presented. Computer Programming in Visual Basic (VBA) — Part 1 and Part 2 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 and Part 2 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.

177-Programming MS Excel in Visual Basic (VBA). Part 3: Functions, Procedures, and String Va
Thomas C. Ferguson, PE
03/29/2018
Verified Buyer
Informative and useful for me professionally in my geotechnical engineering career.
1 of 1 customers found this helpful.
Was this helpful?
177-Programming MS Excel in Visual Basic (VBA). Part 3: Functions, Procedures, and String Va
Philip Taylor
02/26/2018
Verified Buyer
I found this to be another excellent course in this series on programming Excel in VBA. If the student has not had any prior VBA programming training or experience, I strongly recommend working through the courses in sequence since concepts used in later courses to build on those introduced in earlier courses.
1 of 1 customers found this helpful.
Was this helpful?
177-Programming MS Excel in Visual Basic (VBA). Part 3: Functions, Procedures, and String Va
Brian W. Braudaway
01/08/2018
Verified Buyer
Course is clear and to the point. The Problems worked allow the student to imagine many other opportunities to apply the knowledge.
Was this helpful?
177-Programming MS Excel in Visual Basic (VBA). Part 3: Functions, Procedures, and String Va
Michael Post
09/13/2017
Verified Buyer
The screenshots help immensely in understanding the concepts.
Was this helpful?
177-Programming MS Excel in Visual Basic (VBA). Part 3: Functions, Procedures, and String Va
Charles Perryman, PE
02/27/2017
Verified Buyer
This is the third VBA course I've taken from SunCam. All three are good courses. The author writes clearly and is highly accurate. Projects are challenging, but make the necessary connection to the course material.
Was this helpful?
177-Programming MS Excel in Visual Basic (VBA). Part 3: Functions, Procedures, and String Va
Chris Swenson
02/18/2017
Verified Buyer
Very good continuing introduction to VBA. I feel ready to take on various programming!!
Was this helpful?
177-Programming MS Excel in Visual Basic (VBA). Part 3: Functions, Procedures, and String Va
Tom Lyons
02/04/2017
Verified Buyer
Excellent course. Thorough examples. However, there were some typos in the coding - referring to "Lastname" in the middle and "Lasttname" in the end.
Was this helpful?
177-Programming MS Excel in Visual Basic (VBA). Part 3: Functions, Procedures, and String Va
Kevin Hoshstrasser
01/25/2017
Verified Buyer
Great courses. Learned BASIC programming years ago, nice to relearn it and apply it to everyday life. I've tried reading the book, but this course put it all together for me. Thanks.
Was this helpful?
177-Programming MS Excel in Visual Basic (VBA). Part 3: Functions, Procedures, and String Va
Douglas Posey
12/17/2016
Verified Buyer
Good Course and was easier to follow than the first 2 courses in this series. I still cannot write more than a simple program but I have enough information that with more practice, I think I can begin to write programs.
Was this helpful?
177-Programming MS Excel in Visual Basic (VBA). Part 3: Functions, Procedures, and String Va
William Randall
11/07/2016
Verified Buyer
Good course, but again, VBA 6 was already completed when I downloaded the course, so I could only review what was done, not walk myself through it.
Was this helpful?
177-Programming MS Excel in Visual Basic (VBA). Part 3: Functions, Procedures, and String Va
09/30/2016
Verified Buyer
Terrific job by the teacher. I loved his detailed walk-through and will find his course material a great reference for future VBA work.
Was this helpful?
Use It or Lose It
Edward Kranz
04/03/2016
Verified Buyer
This session covered many useful tools to be used in VBA and showed me that there are so many more that are available. I started to feel a little overwhelmed, but then remembered the suggestions on how to write a program introduced in the previous 175 and 176 courses. So I will start incorporating VBA into my work.
Was this helpful?
Good Course
anonymous
05/13/2015
Informative course on visual basic. Good examples.
Was this helpful?
Some things that need fixing on this course.
David Lippe
04/10/2015
On the course text, page 59, there is an error in the example.

The intMonth of DatePart("m", dteStartDate) should be 9, not 3.

on the test, Question 24, answer C. the CStr is misspelled to be CSrt. I guess I just knew what you were trying to ask.
Was this helpful?
(no title provided)
anonymous
03/16/2014
Very useful; great presentation. Test needs a proofreading
Was this helpful?
(no title provided)
anonymous
03/08/2014
A very nice progression with the VBA courses. Thank you.
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-03
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.6) 69 Reviews
4 $90.00
This Course Includes FREE Software




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.