tool tip help for UDF functions

[TimFoley]

Is there a way in 2007 to have a UDF display a tool tip for its parameters like the internal Excel functions?

eg vlookup displays VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

 

[Jerry Sullivan]

Hi Tim,

As far as I know, xl2007 and earlier doesn't have a means to have the argument descriptions appear next to the Formula Box like built-in functions.

John Walkenbach's site explains how to provide some argument descriptions for UDF's using xl2010. However, to see these descriptions the user needs to choose a function using the Insert Function dialog box. Before xl2010, even that limited capability wasn't available.

Spreadsheet Page Excel Tips: User-Defined Function Argument Descriptions In Excel 2010