Flylib.com
List of Sidebars
Previous page
Table of content
Next page
Chapter 2: Excel in a Nutshell
How Big Is a Worksheet?
What's New in Excel 2007?
What's New in the Visual Basic Editor?
Chapter 3: Formula Tricks and Techniques
Referencing Data in a Table
Hidden Names
The Secret to Understanding Cell and Range Names
Chapter 4: Understanding Excel's Files
Workspace Files
Before You Edit the Registry
Chapter 6: Essentials of Spreadsheet Application Development
Learning While You Develop
Menu and Toolbar Compatibility
Bugs? In Excel?
What about Beta Testing?
How Secure Are Excel's Passwords?
Why Is There No Runtime Version of Excel?
Chapter 7: Introducing Visual Basic for Applications
Is VBA Becoming Obsolete?
An Analogy
What's New in the VBE?
Pause for a Terminology Break
The Personal Macro Workbook
About the Code Examples
Specifying Arguments for Methods and Properties
Using the Help System
Working with Merged Cells
Chapter 8: VBA Programming Fundamentals
Entering VBA Code
Benchmarking Variant Data Types
A Note about the Examples in This Chapter
Another Way of Data-Typing Variables
Variable Naming Conventions
About Excel's Date Bug
The MsgBox Function
VBA's IIf Function
What Is Structured Programming?
Chapter 9: Working with VBA Sub Procedures
Naming Procedures
Why Call Other Procedures?
Using Public Variables versus Passing Arguments to a Procedure
Chapter 10: Creating Function Procedures
What Custom Worksheet Functions Can't Do
Reinventing the Wheel
Controlling Function Recalculation
Use Arguments, Not Cell References
Chapter 11: VBA Programming Examples and Techniques
Using the Examples in This Chapter
Tips for Working with Ranges
Testing for Membership in a Collection
An Easier Way to Access the Registry
Chapter 12: Custom Dialog Box Alternatives
Executing an Old Menu Item Directly
Chapter 13: Introducing UserForms
Using Controls on a Worksheet
Testing a UserForm
About the Tag Property
Understanding the Controls Collection
Emulating Excel's Dialog Boxes
Chapter 15: Advanced UserForm Techniques
Displaying Progress in the Status Bar
Chapter 16: Developing Excel Utilities with VBA
Installing an Add-In
Undoing a VBA Procedure
Chapter 17: Working with Pivot Tables
What's New in Excel 2007 Pivot Tables?
Chapter 18: Working with Charts
Compatibility Note
Creating a Chart the Old Way
What's Your Name ?
Understanding a Chart's SERIES Formula
Chapter 19: Understanding Excel's Events
Events in Older Versions of Excel
Using the Object Browser to Locate Events
Chapter 20: Interacting with Other Applications
Displaying a Folder Window
GetObject versus CreateObject
Chapter 21: Creating and Using Add-Ins
About COM Add-Ins
A Few Words about Passwords
About Excel's Add-In Manager
Creating an Add-In: A Checklist
Sleuthing a Protected Add-In
Chapter 22: Working with the Ribbon
The CommandBar Object in Excel 2007
About the Quick Access Toolbar
See Your Errors
Using imageMso Images
Chapter 23: Working with Shortcut Menus
Finding a Control
Finding FaceID Images
Chapter 24: Providing Help for Your Applications
Online Help?
About the Examples in This Chapter
Using Control Tips in a UserForm
Microsoft's Help System Evolution
Displaying an Excel Help Topic
Chapter 25: Developing User-Oriented Applications
Creating the Loan Amortization Wizard
Application Development Checklist
Chapter 26: Compatibility Issues
The Office 2007 Compatibility Pack
Determining Excel's Version Number
Chapter 27: Manipulating Files with VBA
Excel's Text File Import and Export Features
Chapter 28: Manipulating Visual Basic Components
An Important Security Note
Chapter 30: Working with Colors
More about Decimal Color Values
Chapter 31: Frequently Asked Questions about Excel Programming
What If My Question Isn't Answered Here?
Appendix A: Excel Resources Online
Tips for Posting to a Newsgroup
Previous page
Table of content
Next page
Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
ISBN: 0470044012
EAN: 2147483647
Year: 2007
Pages: 319
Authors:
John Walkenbach
BUY ON AMAZON
Crystal Reports 9 on Oracle (Database Professionals)
Connectivity, Authentication, and Privileges
Oracle SQL
PL/SQL
Optimizing: The Oracle Side
Other Tips
MySQL Stored Procedure Programming
Conclusion
Advantages of Stored Programs
Conclusion
Tuning Stored Programs and Their SQL
Conclusion
ERP and Data Warehousing in Organizations: Issues and Challenges
The Second Wave ERP Market: An Australian Viewpoint
The Effects of an Enterprise Resource Planning System (ERP) Implementation on Job Characteristics – A Study using the Hackman and Oldham Job Characteristics Model
Context Management of ERP Processes in Virtual Communities
Healthcare Information: From Administrative to Practice Databases
Development of Interactive Web Sites to Enhance Police/Community Relations
C++ GUI Programming with Qt 3
Using the Reference Documentation
Built-in Widget and Dialog Classes
Implementing Application Functionality
XML
Multithreading
The Lean Six Sigma Pocket Toolbook. A Quick Reference Guide to Nearly 100 Tools for Improving Process Quality, Speed, and Complexity
Using DMAIC to Improve Speed, Quality, and Cost
Value Stream Mapping and Process Flow Tools
Data Collection
Variation Analysis
Identifying and Verifying Causes
Microsoft Visual Basic .NET Programmers Cookbook (Pro-Developer)
Strings and Regular Expressions
Objects, Interfaces, and Patterns
Multithreading
Windows Programming
Remoting and Enterprise Services
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies