Excel 97 Programming for Windows for Dummies
* Save time and improve accuracy by automating common tasks
* Design custom dialog boxes to suit your and your organization's needs
* Build specialized functions to use in your worksheets
* Create add-ins, take advantage of the Windows API, and define custom data types
With numerous books and articles on Excel to his credit, John Walkenbach is the ideal author to make Excel programming understandable, whether you're new to programming or just new to this latest release of Excel.
Table of Contents
PART I: Introducing VBA.
Chapter 1: What Is VBA?
Chapter 2: Jumping Right In.
PART II: How VBA Works with Excel.
Chapter 3: Introducing the Visual Basic Editor.
Chapter 4: Introducing the Excel Object Model.
Chapter 5: VBA Subroutines and Functions.
Chapter 6: Using the Excel Macro Recorder.
PART III: Programming Concepts.
Chapter 7: Essential VBA Language Elements.
Chapter 8: Working with Range Objects.
Chapter 9: Using VBA Functions and Excel Functions.
Chapter 10: Controlling Program Flow and Making Decisions.
Chapter 11: Automatic Procedures and Events.
Chapter 12: Error-Handling Techniques.
Chapter 13: Bug Extermination Techniques.
Chapter 14: VBA Programming Examples.
PART IV: Developing Custom Dialog Boxes.
Chapter 15: Custom Dialog Box Alternatives.
Chapter 16: Custom Dialog Box Basics.
Chapter 17: Using Dialog Box Controls.
Chapter 18: Dialog Box Techniques and Tricks.
PART V: Creating Custom Toolbars and Menus.
Chapter 19: Customizing the Excel Toolbars.
Chapter 20: When Excel's Normal Menus Aren't Good Enough.
PART VI: Putting It All Together.
Chapter 21: Creating Worksheet Functions -- and Living to Tell about It.
Chapter 22: Creating Excel Add-Ins.
Chapter 23: Creating Excel Applications for Other Users.
PART VII: The Part of Tens.
Chapter 24: Top Ten VBA Tips and Tricks.
Chapter 25: Top Ten VBA Questions (And Answers).
Chapter 26: Top Ten Excel Resources.
Sign up now »
- FTLead Software EngineerSA
- FTFlash / ActionScript Developer - ContractNSW
- FTSenior Python DeveloperNSW
- FTR&D EngineerSA
- FT.NET - Sitecore Developer - Melbourne - PermNSW
- FTTechnical Business AnalystNSW
- FTQuality ManagerSA
- FTOS Web Applications DeveloperNSW
- FTJob Title: Mac Systems/ Enterprise Systems EngineerNZ
Businesses face a constantly evolving threat landscape. One of the greatest challenges is presented by advanced persistent threats (APTs), which are sophisticated, multi‐faceted attacks targeting a particular organisation. Mitigating the ...
The nature of work has changed fundamentally and forever and it continues to evolve rapidly. Geographic distance and ...
"Suggesting that people's "purpose is to get information to flow through the ..."
Why change management doesn’t work
"Darn those pesky laws that get in the way of commercial exploitation ..."
Larry Page wants to see your medical records
"Instead of partitioning the device between corporate and personal data, another approach ..."
Dual-Persona Smartphones Not a BYOD Panacea
"Well that's a nice back-handed compliment isn't it? So now, finally, my ..."
After two-year hiatus, EFF accepts bitcoin donations again
"Actually, both Mobile App developers and CIOs should be blamed for it. ..."
CIOs struggle to deliver timely mobile business apps: survey
- AusCERT 2013: Four dissenters to spur next year's security debates
- AusCERT 2013: Kill the password, says Mozilla
- AusCERT 2013: Unmanaged, unknown privileged logins opening the door for APTs: Cyber-Ark
- AusCERT 2013: Companies unaware of IPv6 security risk even if they’re not using it
- Researchers find unusual malware targeting Tibetan users in cyberespionage operation
- Analytics and personalisation drive leading marketer behaviour: Report
- Innovation and big data take centre stage during CMO panel
- Twitter targets second screen interaction with Amplify advertising partnerships
- Facebook talks hyper-targeting, analytics and cross-platform at AANA event
- Tapping into social experience: Tourism Australia