How to get Formula Tips to appear?
 

Hi guys,
I use VBA mainly to write extra formulas for myself to use.
When you type formulas like sum( this stuff usually comes up:

SUM(number1,number2, ...)

Well, i was wondering how to make my own code for that to appear to use
with my own functions. Eg. i made a Distance forula:
=DIST(Easting1,Northing1,Easting2, Northing2)

How do i get that to display when i try to type it in the formula
window in excel?

Thanks in advance, Andre



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

How to get Formula Tips to appear?
 

It shouldn't work any different than for the built in formulas for the
information you show.

if I put in

=Dist and then hit ctrl+shift+a
it did the same as when I did
=Sum and then hit ctrl+shift+a
--
Regards,
Tom Ogilvy


BOMB3RMAN wrote in message
...
Hi guys,
I use VBA mainly to write extra formulas for myself to use.
When you type formulas like sum( this stuff usually comes up:

SUM(number1,number2, ...)

Well, i was wondering how to make my own code for that to appear to use
with my own functions. Eg. i made a Distance forula:
=DIST(Easting1,Northing1,Easting2, Northing2)

How do i get that to display when i try to type it in the formula
window in excel?

Thanks in advance, Andre



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

How to get Formula Tips to appear?
 

Wooww so cool thanks alot :D


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/