Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 21st 03, 11:08 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2003
Posts: 5
Default Commenting custom formula fields/formula on formula editor

When you build custom formulas w/ VBA, how do you comment the input fields?


Example: If you click on the edit formula button "=", then click on the
functions drop down box and let's say you select "sum" if you click on
the "Number1" field at the bottom of the formula editor shows a brief
explanation of the data to be typed and a description of the formula
itself. How does one do the same thing with code.

Regards!


  #2   Report Post  
Old July 21st 03, 11:31 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2003
Posts: 14
Default Commenting custom formula fields/formula on formula editor

the following code will give an overall description for your function,

Sub NameFuntion()
Application.MacroOptions macro:="Name of your Function",
Description:="Your Description"
End Sub

Not sure how to enter a description for each variable though



  #3   Report Post  
Old July 24th 03, 01:02 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2003
Posts: 5
Default Commenting custom formula fields/formula on formula editor

Gord Dibben wrote:
You could do this manually if you just want a description of the Function and
an example.

ToolsMacroMacros. Type in the name of your Function then Optionst. Type in
a description as below.......

This Function Places the Workbook Created Date in a cell. usage is:
=CreaDate()

Note: You cannot enter arguments descriptions in this manner.

You could do it using Laurent Longre's FUNCUSTOMIZE.DLL downlaodable in a
*.ZIP file from his site. If you go this route, check out the Demo that comes
with it.

http://longre.free.fr/english/index.html#FunCustomize

Gord Dibben Excel MVP - XL97 SR2 & XL2002


On Mon, 21 Jul 2003 22:08:48 GMT, Muxer wrote:


When you build custom formulas w/ VBA, how do you comment the input fields?


Example: If you click on the edit formula button "=", then click on the
functions drop down box and let's say you select "sum" if you click on
the "Number1" field at the bottom of the formula editor shows a brief
explanation of the data to be typed and a description of the formula
itself. How does one do the same thing with code.

Regards!



Thanks guys!

Although this would do for now. I would still like to know how to give a
descrbtions of the variables. I will post ansewer if I find out.

Thanks again!
Muxer



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
custom field with custom formula in pivot table! Sedaghat Nejad Excel Worksheet Functions 2 June 21st 09 11:19 AM
IF formula and date fields SCP1 Excel Worksheet Functions 2 June 4th 09 05:02 PM
MAX formula and 'empty fields' David Brereton[_2_] Excel Discussion (Misc queries) 1 August 28th 08 01:44 PM
Formula Editor Result Different than the one in the Cell? kissingurami Excel Discussion (Misc queries) 1 November 25th 07 01:50 PM
Formula editor??? Zilla[_2_] Excel Worksheet Functions 2 February 21st 07 01:22 AM


All times are GMT +1. The time now is 01:59 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017