Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Bar Syntax Tips Disappeared! | Excel Discussion (Misc queries) | |||
VBA to add Tool Tips | Excel Discussion (Misc queries) | |||
Tool tips for UDF | Excel Worksheet Functions | |||
need some tips! | Excel Worksheet Functions | |||
How to get Formula Tips to appear? | Excel Programming |