Microsoft Excel 97/Visual Basic Step by Step [With CDROM]

by Reed Jacobson

Book Overview

With this book and Microsoft Excel 97, you'll learn to use Visual Basic for Applications to build a Microsoft Excel application with Visual Basic for Applications, create custom worksheet functions,... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 1572313188
• ISBN13: 9781572313187
• Release Date: January 1997
• Publisher: Microsoft Press
• Length: 368 Pages
• Weight: 1.75 lbs.
• Dimensions: 1.1" x 7.4" x 9.2"

Customer Reviews

An ideal introduction

This book can teach anyone to program in visual basic!To get the most from this book you have to work through it methodically, doing all the exercises. If you have SOME experience of Excel macros, then you will be very tempted to skip the early chapters. Dont!! There are lots of very useful tips hidden in the text.The book goes to a fairly advanced level, but does tend to rush through the advanced topics.As a reference book its not very good, as it is near impossible to find what you are looking for. Many times I have half remembered something and not been able to find it again.But as a teaching aid it is second to none. I am regularly asked to write simple macros for other people. These days I just give them this book and tell them to spend a couple of afternoons working through it!

Excellent introduction of Visual Basic for Excel

This book was exactly what I needed: a good introduction to Visual Basic and how to use it in Excel 97. It assumes no prior VB experience, but it helps to have some programming experience to understand the vocabulary and concepts used. You will never be able to use Excel 97 to its full potential without knowledge of VB, trust me. I am continously amazed at the flexibility and power of Microsoft Office. This book allows Excel users to unlock this power. It should be noted that this book is not made as a reference, but as something to read from front to back.

great book

Excellent book for people who know zero about visual basic. When you finished reading the book, you will be able to program excel using visual basic. The book will not make you an advanced user, but it is an excellent start.

One of the most helpful I've ever read

I use VB, SQL, Access and Excel every day in my position as a DBA/Analyst. I have no less than 15 reference guides on my desk @ all times. This is the first book that I feel comfortable recommending to someone who wants to learn more about the ins and out of Excel. In the one week that I have had it, I have already learned some new automation tips that have helped my in my daily responsibilities.

Excellent! Excellent! Excellent!

This is an excellent self-study guide for learning VBA for Excel 97! I am a long-time Lotus 1-2-3 user and am very proficient with Lotus Macros. Our company is making the switch to Excel 97, and since my job is to develop spreadsheet applications for our company, I needed to learn how to write detailed macros and create user friendly forms and customize menus in Excel 97. I have been to two classes taught locally for VBA Excel, however, they used version 7.0, and didn't offer it in version 97. The User Forms and Customized Menus differ from version 7.0 to version 97 and the instructors at the classes I attended could not show me the differences because they only used 7.0 ... so I found this book and decided to buy it. I got excited during Lesson 1 because I picked up a few new pointers! By the time I got to lesson 3, I was singing the praises of this book! In EVERY lesson, I was learning new things! This book is well written and easy to read, however, it also takes you into some detailed and intense topics that can take a while to digest. This book starts out with teaching you how to record a simple macro and walks you through and explains the Visual Basic commands the macro created. It then gets into more complex macro tasks including Excel's Object Library, Range Objects, Graphical Objects, Pivot Tables, Custom Menus and Custom Forms. This book comes with a CD that contains interactive lessons. There are twelve lessons in the book and you can go at your own pace. I would especially recommend this book to anyone who is a Lotus 1-2-3 Macro Guru and needs to learn how to create custom applications in Excel 97.