Review of: Programming Excel in Visual Basic Part 2: Branching, Looping, Message Boxes, Alerts
Rodney Matthews
12/05/2022
Verified Buyer
very good. Recommend to anyone interested in programming.
Was this helpful?
Review of: Programming Excel in Visual Basic Part 2: Branching, Looping, Message Boxes, Alerts
Steve Torkildson
06/28/2022
Verified Buyer
Part 2 was like an enjoyable game. The author included an intentional error in the example code. Thinking myself clever, I corrected it as I followed along writing my own version of the code. Then the student was told to run the code to check for errors. That's when I found out that the error I had discovered was done intentionally to give the student experience. Nothing is as cold blooded as a VBA error message.
Was this helpful?
Review of: Programming Excel in Visual Basic Part 2: Branching, Looping, Message Boxes, Alerts
Marino
12/27/2021
Verified Buyer
Very straight forward concepts.
1 of 1 customers found this helpful.
Was this helpful?
Review of: Programming Excel in Visual Basic Part 2: Branching, Looping, Message Boxes, Alerts
Robert Borden
11/11/2021
Verified Buyer
The course is very good, but it took me about 8 hours to complete in this format.
It should be worth more than 4 PDH credits
Was this helpful?
Review of: Programming Excel in Visual Basic Part 2: Branching, Looping, Message Boxes, Alerts
James Sanford
07/23/2021
Verified Buyer
Some of the Yes/No logic on the flow chart for the speed humps project match neither the problem statement nor the code.
Was this helpful?
176-Programming Excel in Visual Basic Part 2: Branching, Looping, Message Boxes, Alerts
WOW! Very powerful tools for engineers. Highly recommended.
Was this helpful?
176-Programming Excel in Visual Basic Part 2: Branching, Looping, Message Boxes, Alerts
Excellent !!!
Was this helpful?
176-Programming Excel in Visual Basic Part 2: Branching, Looping, Message Boxes, Alerts
Victor Suben
05/29/2020
Verified Buyer
This section is very thorough in showing the use of loops, dashboards, etc.
Was this helpful?
176-Programming Excel in Visual Basic Part 2: Branching, Looping, Message Boxes, Alerts
04/04/2020
Verified Buyer
Good layout and easy to follow.
1 of 1 customers found this helpful.
Was this helpful?
176-Programming Excel in Visual Basic Part 2: Branching, Looping, Message Boxes, Alerts
Tommy Setzer
10/14/2019
Verified Buyer
Good overview
2 of 2 customers found this helpful.
Was this helpful?
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
John Farrell
02/19/2019
Verified Buyer
Good continuing basic tutorial in spreadsheet programming.
Was this helpful?
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
V Trujillo
12/04/2018
Verified Buyer
I enjoyed the introductory course.
Was this helpful?
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
D. Voorhis
09/22/2018
Verified Buyer
The examples and the labeled figures in the course really help in understanding the concepts being presented.
Was this helpful?
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
Pascal Hayes
08/12/2018
Verified Buyer
Very description and comprehensive treatment of the subject
Was this helpful?
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
Douglas Durden
06/14/2018
This course is a very good introduction to the topic of conditional statements and looping in Visual Basic. The test reflects fairly the material covered. The example projects are instructive and adequately challenging. They reinforce the text material well. Overall, this is a very good introductory course.
Was this helpful?
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
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.
1 of 1 customers found this helpful.
Was this helpful?
176-Programming MS Excel in Visual Basic (VBA). Part 2: Branching & Looping, Message Box
Charles English
12/17/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/18/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/22/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.
2 of 2 customers found this helpful.
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
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)
Good course.
Was this helpful?
(no title provided)
Just the right amount of material.
Was this helpful?
Takes 12 hours to perfect it for 4 PDH?
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)
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
2 of 2 customers found this helpful.
Was this helpful?
(no title provided)
A very nice next step from 175. This is beginning to make VBA truly useful.
Was this helpful?
