| 416-621-9348 cgreaves@chrisgreaves.com | .JPG) |
|---|---|
| Home Services Products |
How To Build an Excel Library (Home); You Gotta Start Somewhere ; Creating A Function Library ; Compiling A Workbook To A Library ; Creating A Macro Library ; Referencing A Library ; A Toolbar Menu ; Making The Macro Library Available ; Some Minor Points ; Maintaining The Utility Function Library ; End-users And The Utility Function Library
End-users And The Utility Function Library
Your end-users will love you.
Once your Utility Function library is in place, end-users can make use of your existing functions (or suggest new functions to you).
We have opened a new workbook and typed a person’s identity as four names separated by the space character.
In an empty cell we have called up the function-picker, browsed to User-defined functions, and selected our new hand-built utility function.
The function picker makes our little function appear quite professional.
We point the first parameter to the cell holding our name, and we type the spacebar just once in the second box.
We are rewarded with the leftmost part of the original string, split off at the space character.
Our way is now clear to develop functions to satisfy the business requirements of our organization.
The world is ours!
Loading
Toronto and Mississauga, Friday, December 03, 2010 8:44 AM
Copyright © 1996-2010 Chris Greaves. All Rights Reserved.