177-Programming Excel in Visual Basic Part 3: Functions Procedures & String Variables

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

Preview Course Read/Print Test Author's Page

Having trouble opening course PDF documents?

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 Excel in Visual Basic Part 3: Functions Procedures & 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.

Questions about this course? Email the Author: kwabena@kbofosu.com

Star (18)
Star (5)
Star(0)
Star (0)
Star (0)

(4.8) 23 Reviews

Review of: Programming Excel in Visual Basic Part 3: Functions Procedures & String Variables

Rodney Matthews

12/05/2022

Very good. Recommend to anyone interested in programming.

1 of 1 customers found this helpful.

Was this helpful?

Review of: Programming Excel in Visual Basic Part 3: Functions Procedures & String Variables

James Sanford

07/23/2021

Verified Buyer

I disagree with your answer to test question # 23 . . .

Portions of the reviewers comments have been removed because they discuss the answers to test questions

Was this helpful?

177-Programming Excel in Visual Basic Part 3: Functions Procedures & String Variables

Victor Suben

06/02/2020

Verified Buyer

This course makes it easy to understand string variables, and the different methods of utilizing them in a program

Was this helpful?

177-Programming Excel in Visual Basic Part 3: Functions Procedures & String Variables

Roger Walker

03/29/2020

Verified Buyer

I just sent a response which I indicated an incorrect answer to #4. This was my mistake. The test was good. Thanks

Was this helpful?

177-Programming Excel in Visual Basic Part 3: Functions Procedures & String Variables

Tommy Setzer

10/15/2019

Verified Buyer

Good course.

Was this helpful?

177-Programming Excel in Visual Basic Part 3: Functions Procedures & String Variables

Daniel Cost

05/16/2019

Verified Buyer

Excellent course for growing VBA skill set

Was this helpful?

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

Phil Givens

10/23/2018

Verified Buyer

This course is excellent. The most useful information I have ever come across in meeting my continuing education requirements.

Was this helpful?

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/09/2014

A very nice progression with the VBA courses. Thank you.

2 of 2 customers found this helpful.

Was this helpful?

SAVE 20%

Order the Complete Set of 4 Courses for $288.00!

Click Here to Order & Save

You Must Use This Button to Get The Savings

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 US states, territories, the District of Columbia, and Canadian provinces except: Ohio

About Course Approvals