ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how do i create help text to personal function? (https://www.excelbanter.com/excel-programming/329201-how-do-i-create-help-text-personal-function.html)

DOV

how do i create help text to personal function?
 
Hi,
Is it possible to ad help context to a personal function I create in vbe?
If yes then, how?
Thanks.
dov

david mcritchie

how do i create help text to personal function?
 
It is not easy for you to add HELP to each argument of your User Defined Functions

The parameter cell will show up in the Function Wizard Help without any intervention, so choose your parameter names carefully. The
description can be entered as follows: Alt+F11 (VBE), F2 (View, Object Browser), Select the module (or <globals) on left, select
the function on right, RClick, properties, fill in description.

To add a description for each argument will take a lot more work. Laurent Longre
has an addin to help with that -- more information and links to his addin at...

Entering a Description for the Function Wizard (Shift+F3): in XL2000
http://www.mvps.org/dmcritchie/excel/install.htm#fx
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"dov" wrote in message ...
Hi,
Is it possible to add help context to a personal function I create in vbe?
If yes then, how?
Thanks.
dov







All times are GMT +1. The time now is 07:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com