LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default User defined Spreasheet Functions - How to add "help/ assistance comments"

I would greatly appreciate some advice with the following:


I am defining some "user defined spreadsheet functions" of
my own. How can I include some "on-line" help comments to
be displayed when the user will be using the new
functions, the same way the built-in Excel functions are
set up. For example, when LOOKUP() function starts, the
comment: "Returns a value from a one-row or a one-column
range of an array" is displayed. Every time the user
clicks on a parameter field, the relevent comment is
displayed, for example for Lookup_value: "Lookup_value is
a value that LOOKUP searches in...," etc.


I have tried to access the member properties in Object
Browser, and include a comment in the description field
for my function. However when I hit OK and re-open, my
comment is not saved...

Thank you in advance,

Adrian


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Message "user defined type not defined" LEELK01 Excel Discussion (Misc queries) 2 August 14th 09 07:31 AM
User Defined Charts-Missing the "Add-Delete" Options. RUSH2CROCHET Excel Discussion (Misc queries) 0 February 15th 07 03:53 PM
User Defined Charts-Missing the "Add-Delete" Options. Joel Excel Discussion (Misc queries) 0 February 15th 07 03:46 PM
How do you save and share "user-defined chart type's" in Excel? Jocelynne Charts and Charting in Excel 1 August 24th 06 08:46 AM
How do you save and share "user-defined chart type's" in Excel? Jocelynne Charts and Charting in Excel 0 August 23rd 06 08:51 PM


All times are GMT +1. The time now is 02:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"