Review of: Programming Excel in Visual Basic Part 4: Errors, Arrays, Dialog Boxes, Charts
MARK ERNEST SELMAN
05/06/2024
Verified Buyer
Excellent
Was this helpful?
Review of: Programming Excel in Visual Basic Part 4: Errors, Arrays, Dialog Boxes, Charts
Reese Finn
12/23/2022
Verified Buyer
Very useful
Was this helpful?
Review of: Programming Excel in Visual Basic Part 4: Errors, Arrays, Dialog Boxes, Charts
RODNEY E MATTHEWS
12/05/2022
Verified Buyer
Very good course. Recommend to anyone learning programming.
Was this helpful?
Review of: Programming Excel in Visual Basic Parts 1,2,3,4
Yves Zornio
10/31/2021
Verified Buyer
The courses were logically presented, detailed enough.
Was this helpful?
Review of: Programming Excel in Visual Basic Part 4: Errors, Arrays, Dialog Boxes, Charts
James Sanford
07/23/2021
Verified Buyer
The description of the file save dialog is vague in that it doesn't really tell me what the CONTENTS of the saved file will be -- what goes there?
Was this helpful?
Review of: Programming Excel in Visual Basic Part 4: Errors, Arrays, Dialog Boxes, Charts
Gordon Bigham
02/27/2021
Verified Buyer
Very good course. It took me more than 4 hours to complete, but it was worth the extra effort to learn the concepts.
Was this helpful?
178-Programming Excel in Visual Basic Part 4: Errors, Arrays, Dialog Boxes, Charts
Victor Suben
06/04/2020
Verified Buyer
Very thorough explanation of program debugging methods.
Was this helpful?
178-Programming Excel in Visual Basic Part 4: Errors, Arrays, Dialog Boxes, Charts
Easy to follow and understand
Was this helpful?
178-Programming Excel in Visual Basic Part 4: Errors, Arrays, Dialog Boxes, Charts
John Barry
02/21/2020
Verified Buyer
Generally useful, but examples more oriented toward engineering work would have been helpful.
Was this helpful?
178-Programming Excel in Visual Basic Part 4: Errors, Arrays, Dialog Boxes, Charts
Pascal Hayes
11/22/2019
Verified Buyer
The course material will remain a useful reference. The very detailed steps presented are valuable to someone like me who knew very little about VBA before taking this series of courses.
Was this helpful?
178-Programming Excel in Visual Basic Part 4: Errors, Arrays, Dialog Boxes, Charts
Tommy Setzer
10/15/2019
Verified Buyer
This course was a big help and the primary reason I took the other three before it.
Was this helpful?
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
Philip Taylor
03/05/2018
Verified Buyer
This course, as the previous three in the series, was excellent. The series is a comprehensive look at introductory VBA programming. It is very useful for an engineer who has facility with Excel but has never taken advantage of the capabilities that VBA programming offers. The only area in this course I wish had been more thorough is the process of using the debugging tools - a few step-by-step examples of how to interact with the debugger (Step Into, Step Over, Step Out, etc.) would be helpful.
Was this helpful?
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
12/28/2017
Verified Buyer
Graphing section is weak. No explanation on how to place on a new sheet, at a specific location on an existing sheet, or code for customizing. The With ... End With statement could use some explanation; I assume it is used for purposes other than working with graphs.
Was this helpful?
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
Nick Halbrook
11/18/2017
Verified Buyer
Again as with the three previous parts this is a simple multiple guess test requiring only reading the course document without needing to write any code to generate answers to questions which is a major course failure IMHO as without this tact it is not possible to test one's ability to demonstrate that one has really learned any VBA programming skills. All four parts are OK as regards presenting VBA programming basics and should allow one to generate effective programs. Question languaging in all parts and especially Part 4 made it difficult to puzzle out what was being asked in some questions especially if one is not familiar with VBA and/or programming lingo/jargon.
Was this helpful?
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
Michael Post
09/17/2017
Verified Buyer
This course provided a good explanation of error handling, arrays and dialog boxes.
It had a couple of confusing areas in it though:
1) In the first input box example, it stated that Text (type:=2) is the default but it saved the number as a double without a type:=1 argument. If the Application class is left off, does it automatically change the type to match the variable to which it is assigned? This should be clarified.
2) In the msoFileDialogOpen example, why are the filters not set before the dialog box is opened using FileChosen = fd.Show? If that is the line that halts the program until the user clicks "open", how does the filter get set? Also, how does the program continue far enough to change the "open" text on the button without reaching the If-Then statement? This is very confusing and an explanation of the program flow may help to clarify it.
3) In the print example, the item text is overwritten by the price values on the spreadsheet. The column numbers should be incremented by 1 in the second For-Next loop.
Thank you.
Was this helpful?
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
W. David Bruce, Ph.D., P.E.
03/01/2017
Verified Buyer
This was a good course, but I found it to be fairly difficult. It would help to have another short example or two specifically dealing with the application of arrays and with outputting the results obtained to an Excel spreadsheet.
Was this helpful?
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
Kevin Hoshstrasser
01/25/2017
Verified Buyer
Thanks for the interesting course, which will serve as my starting point to really delve into VBA. See you in 2 years for my next CE courses.
Was this helpful?
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
Harry Vanpelt
12/13/2016
Verified Buyer
Good review of array use, error handling and charting
Was this helpful?
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
William Randall
11/09/2016
Verified Buyer
The course was locally presented and the examples were very useful and easy to understand.
Was this helpful?
178-Programming MS Excel in Visual Basic (VBA). Part 4: Error Handling, Arrays, Dialog Boxes
Marlin Vrbas
04/16/2016
Verified Buyer
This was pretty good! I have used VBA as a major part of my livelihood for about 20 years, and I find myself using the same tricks over and over. Now I have some new tricks!
Improvement? This course was supposed to be standalone. But the seventh VBA project seems to be based on a project from an earlier course that I did not take. A little bit of inconsistency, but did not detract from the overall quality or my ability to get the continuing ed hours I needed.
Was this helpful?
suspected error in answer choices for question 14
...
Comments about the correct answer to questions have been removed.
Was this helpful?
(no title provided)
Great course on VBA. Extensive examples. A+
Was this helpful?
(no title provided)
very ambiguous for many of the questions
Was this helpful?
