Excel Programming: Your visual blueprint for creating interactive spreadsheets

by Jinjer L. Simon

Excel(r) Programming 2nd Edition

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 120 key Excel programming techniques, including:
* Creating and launching keyboard shortcuts
* Setting macro security
* Assigning a digital signature
* Developing a function with VBA
* Displaying a built-in dialog box
* Converting a list into an array
* Using the msgbox function
* Processing a runtime error
* Saving a workbook in a specified format
* Finding the intersection of two ranges

Genres: Programming, Computers

352 pages, Paperback

First published May 5, 2008

Reviews

[Kevin · Rating 2 out of 5]

The exact opposite of a good code book (e.g. O'Reilly's Programming Perl). The first 100 pages could have been condensed into five pages. There are lots of errors. Parts of it seem like they were processed in Babelfish.

It was the only vba book at Barnes and Noble that was specifically geared for Excel. Should have just gone online.