Tdist not available from visual basic - AS advertised.

[Persnickety]

Although the TDist function is listed in the help files as "workbook functions available in visual basic", in fact, when I go to compile my code, it says "function or sub not available". :x

This is for Excel 2003, SP2 running under Windows XP Professional.

I searched the microsoft knowledge base for 'TDist' but did not find any discussion of the issue.

 

[Joe4]

I got it to work in VBA like this, i.e.

MsgBox Application.TDist(1.96, 60, 2)

There are a number of native Excel functions that require you to user "Application." or "Application.WorksheetFunction." in front of them in order to use them in VBA.

 

[Persnickety]

Hmmmm.....

So, it seems that I don't even have to build a string and pass it to the evaluate method! I'll give this a try.