How to get Formula Tips to appear?

B

BOMB3RMAN

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
 
T

Tom Ogilvy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top