The Excel VBA User Form Conundrum Solved: The slim version with more filling! Paperback – 18 Nov 2011
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
About the Author
Richard Brooks has had an extensive career with a number of Fortune 500 companies. He has worked on the business side managing various departments including Call Centers, Central Communications, Corporate PC Training, Restaurants, Security System Access, Report Development, Inventory Management, and Space Planning divisions. On the IT side, he has designed, engineered and managed the development of corporate applications. During his employment over the years he has been tasked to streamline business processes, improve productivity, and to create a synergy between their existing applications and software products. These challenges have resulted in the production of many powerful user-friendly applications. For this book he has drawn on his experience working with SQL, SharePoint, InfoPath, Crystal Reports, XML, HTML, CSS, .NET, SSRS, VBA, Adobe and numerous Microsoft Office products to name just a few. Each book in the application series of Richard's Journals is based on his journey to produce solid applications that can be utilized for various business and personal needs. Unlike many other books that give you broad answers to your development questions, he has decided to get straight to the point and provide a simple approach to giving clear concise direction for useful projects that can be molded to fit your specific needs. This book is for everyone. The step-by-step direction will give you the edge for your new or existing position within a company. --This text refers to an alternate Paperback edition.
Top customer reviews
Very poor book, very disappointed.
Most helpful customer reviews on Amazon.com
I'd developed userforms before, but they did nothing more than let the user pick a date, or pick one option button that acted as a filter for the program that would then run. Recently though I needed a userform to input data, validate and post it, input more, validate and post that, and back and forth until I was finished. I found enough online help to get the userform to work 90% of the way, but couldn't get one particular problem solved. So I ordered this book, and found my answer - only one line of misplaced code, but still... Even though I didn't need help with the controls this time, Mr Brooks really clarified the relationships between the different subroutines normally associated with userforms and their implementing modules.
The two appendices to this book are nearly worth the price by themselves. Very glad I picked this up. Well done!
Since we do not have an IT department I was left on my own to research my options. My brother suggested I start with User Forms. Every book I came across for Excel gave tidbits of information. Of course none of which was enough for me to fully understand the ins and outs. Then I finally stumbled across this book on amazon.
1) The book offered more than I could have expected to get.
a. Insight into the thought process for creating a well designed form.
b. To my delight. Although the book offered step by step section on how to create each image used in the book. The author offered the images for free from his site.
c. Chapter 7 was an in depth introduction on how to create the user form.
2) I have created 3 different user forms for my company since purchasing this book. The senior executive of my company has given me an award for streamlining our processes, excellence in design and creativity.
Over a two month period of time, I would not have expected to have accomplished so much. I was shocked to read the previous review about this book. Had I seen it before I made my purchase, I might not have bought the book. So here is a translation for these types of negative comments to help you make up your mind.
FOOLISH WORDS FROM SMALL MINDED PEOPLE
A) QUOTE: "As for the example, it does not resemble any kind of a professional image I would introduce into an Excel application with a Fortune 500 company."
TRANSLATION: I lack creativity and do not know how to use the example as a starting point.
NOTE: The author offers the images for FREE on his website. I used it for my first project and it is still being used in the office. Everyone that uses it compliments me about the user form images.
B) QUOTE: "The author provides a web link to download the images he uses in his example but does NOT provide the source code in a downloadable format. A lot of code by I am certainly not going to type it all back in."
TRANSLATION: I am to lazy to type in the code and want the completed project handed to me on a silver platter.
NOTE: By the way, when I reached out to the author about a different subject, he offered to send me the completed code. But, I resisted, because I wanted to understand each nuance of the code for myself and this could only be accomplished if I typed it in.
C) QUOTE: "The example in the book is developed on a Mac and he uses Adobe Fireworks CS and Photoshop CS. Like I am going to go out and buy those products so I can play along with his tutorial?"
TRANSLATION: I did not read the book, except for probably the bolded items.
NOTE: The author stated in his book a user form could be created without the images. With the exception of the first project I created where I used the images provided by the author, for each additional user form I created I did not include one image from Adobe Fireworks CS and Photoshop CS. I used only the tools offered in Excel.
I am a mother of two and this type of off handed negative comments is just pure laziness thru and thru. I hate the thought that someone could have discouraged me from buying this book for no other reason than they had been to lazy to read, type or even consider using a part of their creative brain. The best part of the book has been the Project Overview Checklist. I have used it for each of my user form projects to help keep me organized during the course of my project development.
Best wishes on your decision. I am off to create user form number 4.
I was hoping to find a manual which could help further my knowledge of Excel User Forms when I came upon this book. Well, things did NOT work out.
My initial complaint when I received the actual book is that it is printed in Black & White even though the Guided Tour shows color pictures. Since the author used various colors to highlight his code, in the "grey-scale" printed in the book it is extremely hard to read. I don't know if I just ended up with a misprint but I will not take a chance for the following reasons (this book goes back to Amazon tomorrow!!!)
1) This book is a narrative of a project that the author created and does not offer much insight to creating a User FOrm other than the example presented in the book.
2) As for the example, it does not resemble any kind of a professional image I would introduce into an Excel application with a Fortune 500 company.
3) The author provides a web link to download the images he uses in his example but does NOT provide the source code in a downloadable format. A lot of code by I am certainly not going to type it all back in.
4) The example in the book is developed on a Mac and he uses Adobe Fireworks CS and Photoshop CS. Like I am going to go out and buy those products so I can play along with his tutorial?
OK, so I was hoping for a book where someone would help me design and build better User Forms. I guess I'll keep looking......
Look for similar items by category