I don't think you can add screen tips for a user defined function. The best
you can do is add a description that will show on the Function Arguments
dialog box which the user would access by clicking the Insert Function button
(Fx).

To do this create your function in the VBE. Then open the Object Explorer
(F2). Select VBAProject from the <All Libraries drop down. In the Classes
window select the Module that holds the function. Then right click the
function name in the members window. Select properties and enter your
description.

Note: From what I can see this WILL NOT work if you have already used the
function anywhere in your workbook. The description must be added immediately
after writing the function (Excel 2002 and 2003).

Hope this helps
Rowan

"Nicolás" wrote:

Good afternoon. I'm programming an Excel function using Visual Basic. My
function works, but I want to add it the yellow squares telling what kind of
arguments should I introduce in a particular position.

For example, if you use (in spanish language) the function BUSCARV, as soon
you open the parenthesis apperars a yellow square that shows:

BUSCARV(valor_buscado, matriz_buscar_en, indicador_columnas, [ordenado])

It's like a help to know the arguments to introduce. I want that my function
shows this kind of yellow square to help user know what kind of information
should he use.

Thank you,

Nicolás