customise Insert Function/Function Arguments dialog box
 

It's described he

http://www.jkp-ads.com/Articles/RegisterUDF00.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Martin" wrote in message ...
| I've some UDFs and would like to customise the Insert Function dialog box so
| that, like Excel's own functions, the user is prompted with:
| (a) a general description of the function, followed by
| (b) a section on each individual argument they're filling-in.
|
| I've also been looking at Application.MacroOptions to sort out context
| sensitive help. Is there an equivalent for the above?
|
| Thanks

customise Insert Function/Function Arguments dialog box
 

Thanks very much for that Niek. Amazingly complicated but it does the trick!

"Niek Otten" wrote:

It's described he

http://www.jkp-ads.com/Articles/RegisterUDF00.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Martin" wrote in message ...
| I've some UDFs and would like to customise the Insert Function dialog box so
| that, like Excel's own functions, the user is prompted with:
| (a) a general description of the function, followed by
| (b) a section on each individual argument they're filling-in.
|
| I've also been looking at Application.MacroOptions to sort out context
| sensitive help. Is there an equivalent for the above?
|
| Thanks