Can an Excel VBA UDF called from the worksheet ever be passed an instance of any Excel VBA object mo
- by jtolle
I'm 99% sure that the answer is "no", but I'm wondering if someone who is 100% sure can say so.
Consider a VBA UDF:
Public Function f(x)
End Function
When you call this from the worksheet, 'x' will be a number, string, boolean, error, array, or object of type 'Range'. Can it ever be, say, an instance of 'Chart', 'ListObject', or any other Excel-VBA object model class?
(The question arose from me moving to Excel 2007 and playing with Tables, and wondering if I could write UDFs that accept them as parameters instead of Ranges. The answer to that seems to be no, but then I realized I didn't know for sure in general.)