John Walkenbach, "Excel VBA Programming For Dummies"
For Dummies | 2004 | ISBN: 0764574124 | 408 pages | PDF | 11 MB
For Dummies | 2004 | ISBN: 0764574124 | 408 pages | PDF | 11 MB
Having Excel and just using it for standard spreadsheets is a little like getting the ultimate cable system and a 50” flat panel plasma HDTV and using it exclusively to watch Lawrence Welk reruns. With Visual Basic for Applications (VBA) programming, you can take advantage of numerous Excel options such as: creating new worksheet functions; automating tasks and operations; creating new appearances, toolbars, and menus; designing custom dialog boxes and add-ins; and much more.