Functions and their category

[wigi]

Hello all

Does anyone know a way to loop through the different categories of functions? You know, Financial, Date & Time, Math & Trig, Statistical, Engineering, ...

Can you read out the the category to which a function belongs?

Thanks in advance,

 

[Macropod]

Hi wigi,

Do you mean something like what you see in the 'Paste Function' dialogue box? AFAIK there is no programmatic way to retrieve the groups into which MS has put each of these functions.

 

[wigi]

Hi wigi,

Do you mean something like what you see in the 'Paste Function' dialogue box? AFAIK there is no programmatic way to retrieve the groups into which MS has put each of these functions.

Well, the functions you see when you choose Insert > Function.

Mee too, I'm afraid it's impossible.

Wigi

 

[xenou]

Not sure if this is relevant but there was thread on accessing info from the object browser - which may be a way to list functions (but I don't know if their categories are in there).

http://www.mrexcel.com/forum/showthread.php?t=363354&highlight=object+browser