Logo 
Search:

MS Office Forum

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

description/help with own VBA functions in Excel

  Asked By: Adella    Date: Mar 02    Category: MS Office    Views: 1257
  

I am new to VBA with Excel and I have made a few functions now using
VBA for Excel. These work nicely, but I would like to add the short
help messages for when I do a 'Paste function' in a cell.

For both to function description and for each argument. Now I always
see the text 'Choose the Help button for help on this function and its
arguments'. Is it possible to define these 'help' lines as part of the
Function definition in VBA?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Karla Ortiz     Answered On: Mar 02

Excel doesn't give you the ability to add  help messages  for your user-defined
function and its arguments. It is possible to do, but is complicated. The
following link has information on the workaround:


www.dicks-blog.com/.../registering-a-user-defined-functio\
n-with-excel/

 
Answer #2    Answered By: Anu K     Answered On: Mar 02

Thanks for this link, I will try and see how it works on XP...

 
Didn't find what you were looking for? Find more on description/help with own VBA functions in Excel Or get search suggestion and latest updates.




Tagged:        

 
 
 
 

Related Post