A fast, easy way to learn to program with Visual Basic for Applications, to extend and modify Microsoft Excel behavior, and to take full advantage of the Internet. The easy-to-follow lessons include clear objectives and real-world business examples so you can learn exactly what you need to know, at your own speed. The CD-ROMs offer real-world samples to support each lesson.
Book Description
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
112 of 113 people found the following review helpful:
4.0 out of 5 stars
Good for class, not for a non-programmer,
By
This review is from: Microsoft Excel 2000/Visual Basic for Applications Fundamentals (Paperback)
I am using this book as the textbook for a class that I'm teaching on VBA in Excel. This book is good for use in a class because I'm there to clarify a lot of issues. I don't think the book is very good for a non-programmer who is trying to learn VBA. The author assumes that the reader has a decent understanding of programming in general, and in specific an understanding of objects. The students who have looked through the book like it and are ordering their own copies (one copy was provided to each for in-class use). The book has real applications, which is extremely useful for helping students remember what they did. The author uses a different programming technique than I, so I am learning new ways of writing code. To improve the book, I would explain the concept of a variable and object in the first chapter.
44 of 45 people found the following review helpful:
4.0 out of 5 stars
Great starter book for people unfamiliar with VBA Excel,
By
This review is from: Microsoft Excel 2000/Visual Basic for Applications Fundamentals (Paperback)
This was my first book I used to learn the VB intricacies of Excel. Showed me step-by-step what is possible as far as developing a user application, with a VB fueled spreadsheet. One thing that I liked was code that removed all the users toolbars (makes the visual screen area maximized) and the upon closing, puts them all back. Had results in just about a week with some help from the Microsoft news groups (Excel related). Recommended as a starter for those unfamiliar with VB or Excel.
30 of 31 people found the following review helpful:
2.0 out of 5 stars
Not for beginners,
By "absnd" (Manalapan, NJ USA) - See all my reviews
This review is from: Microsoft Excel 2000/Visual Basic for Applications Fundamentals (Paperback)
The book does not do a good job with the fundamentals of VBA. Very brief in its explanation of objects, properties, and methods. Gives plenty of examples but often refers you to Excel help to find out more info about a particular item. If I wanted to do that I would not have bought the book. Very disappointed.
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
First Sentence:
In this chapter, you'll learn how to: Record and run a macro. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
revised macro, highlight the next statement, pivot item, event handler procedures, macros easy, practice files, macro recorder, workbook object, spin button, report worksheet, active workbook, original macro, worksheet object, test the macro, turn off the recorder, recorded macro, save the workbook, new workbook, formula bar, workbook window, macro name, detail rows, summary rows, workbook containing, copy mode Key Phrases - Capitalized Phrases (CAPs): (learn more)
End Sub, Microsoft Excel, Record Macro, Object Browser, Private Sub, Exploring Objects, Quick Info, Select Selection, Making Macros Easy, Auto Lists, Down Arrow, Microsoft Office, Miller Textiles, Project Explorer, Enterprise Information System, Exit Sub, High Art, Launching Macros, Modify Selection, Select Range, Assign Macro, Click the Exit Design Mode, Close Window, Close Workbooks, Explore Graphical Objects New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
In this chapter, you'll learn how to: Record and run a macro. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
revised macro, highlight the next statement, pivot item, event handler procedures, macros easy, practice files, macro recorder, workbook object, spin button, report worksheet, active workbook, original macro, worksheet object, test the macro, turn off the recorder, recorded macro, save the workbook, new workbook, formula bar, workbook window, macro name, detail rows, summary rows, workbook containing, copy mode Key Phrases - Capitalized Phrases (CAPs): (learn more)
End Sub, Microsoft Excel, Record Macro, Object Browser, Private Sub, Exploring Objects, Quick Info, Select Selection, Making Macros Easy, Auto Lists, Down Arrow, Microsoft Office, Miller Textiles, Project Explorer, Enterprise Information System, Exit Sub, High Art, Launching Macros, Modify Selection, Select Range, Assign Macro, Click the Exit Design Mode, Close Window, Close Workbooks, Explore Graphical Objects New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Citations (learn more)
Books on Related Topics
(learn more)
|
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
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
