ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Custom functions excel 2003 (https://www.excelbanter.com/excel-worksheet-functions/160094-custom-functions-excel-2003-a.html)

NICOLA-ITALY

Custom functions excel 2003
 
I have made a few custom functions with VBA on a file I saved as an Add-in
with xla extension to make them available anywhere.

For example I included a simple function like:

Function MARGINE(Prezzo, Costo)
MARGINE = (Prezzo - Costo) / Prezzo
End Function

All functions work perfectly, but I would like to include the automatic tip
you have when you use standard built in functions.

To better explain, when you type =LEN( you see on top LEN(text) appearing.
Well, I would like the same to happen with my custom functions, I'd like the
suggestion to appear on the text bar on top: in this example I would like the
tip MARGINE(Prezzo,Costo) to appear on top.
How can I do this?
Nicola


All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com