or
Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Tell the Publisher!
Id like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

The Excel VBA User Form Conundrum Solved: The slim version with more filling! [Paperback]

Richard Brooks
3.0 out of 5 stars  See all reviews (1 customer review)
RRP: 16.02
Price: 14.36 & FREE Delivery in the UK. Details
You Save: 1.66 (10%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 22 Aug.? Choose Express delivery at checkout. Details

Formats

Amazon Price New from Used from
Paperback 14.36  

Book Description

18 Nov 2011
Explore and imagine the possibilities with Excel VBA User Forms! Excel spreadsheets will never look the same! ™ Working with Excel spreadsheets can be very intimidating. Making large amounts of information available to any one person is very risky. The possibility exists that someone could compromise your data due to human error by inadvertently deleting, altering or accidently updating the wrong record. Prevent this from happening by creating a User Form. A User Form is a graphical user interface, also known simply as a form that permits you to control the entry and modification of your data in an Excel spreadsheet. Through a simple approach you can learn how to add full functionality to a User Form that would permit the user to navigate, delete, add, save, update, print, search, open a website or email data. The Excel VBA User Form Conundrum book provides deliciously decadent collection of step-by-step quick and easy to follow insightful instructions for creating powerful, awe-inspiring, professional, elegant, impressive Excel VBA User Forms.


Product details

  • Paperback: 162 pages
  • Publisher: Richard's Journals (18 Nov 2011)
  • Language: English
  • ISBN-10: 0982280106
  • ISBN-13: 978-0982280102
  • Product Dimensions: 27.9 x 21.6 x 0.9 cm
  • Average Customer Review: 3.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 1,100,868 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, and more.

Product Description

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.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Back Cover
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

5 star
0
4 star
0
2 star
0
1 star
0
3.0 out of 5 stars
3.0 out of 5 stars
Most Helpful Customer Reviews
3.0 out of 5 stars Not Bad 26 Mar 2014
By Patrick
Format:Paperback|Verified Purchase
A little awkward to navigate and is more of a set of instructions really that quickly becomes confusing if you skip pages.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 3.7 out of 5 stars  3 reviews
1 of 1 people found the following review helpful
5.0 out of 5 stars Well done! Just what I needed 12 Jun 2013
By M. Warren - Published on Amazon.com
Format:Paperback|Verified Purchase
I have three Excel VBA reference books, the shortest one being 875 pages. They are excellent references, yet none of them really devotes the level of detail to userforms that Mr Brooks does here. In fact, aside from digging through an MS help guide in the software or online (not always as helpful as we'd wish), I don't know of anywhere else to get this level of control-by-control information.

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!
5.0 out of 5 stars My Number One Excel Go To Book for User Forms 19 May 2013
By Office Girl - Published on Amazon.com
Format:Paperback|Verified Purchase
I have worked with Office products for many years. Like many others, dictated by my work, I would dabble with Excel from time to time. My new boss in my department challenged me to come up with a way to make it easier to enter data, make it searchable and allow us to send any information at a moments notice via Outlook when needed. The only caveat was I could only use the office products we had already purchased.

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.
1 of 2 people found the following review helpful
1.0 out of 5 stars Buyer BEWARE 1 April 2013
By Mac-Jim - Published on Amazon.com
Format:Paperback|Verified Purchase
I have never written a review before but this book needs one.

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......
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback