Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
DOV DOV is offline
external usenet poster
 
Posts: 4
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 691
Default 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





Reply
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
create personal macro workbook krispylala Excel Worksheet Functions 3 December 6th 07 04:38 PM
Create text pop-up in VBA function jimmy_chu Excel Programming 0 December 10th 03 03:57 PM


All times are GMT +1. The time now is 01:25 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"