Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've made a custom object with a 'Function' method and need each instance of
the object to call a different UDF. Is there a way if I assign the UDF name to the object's function as a string to call the function. For example; Public Function CalcRainfall(iDate as date) as double 'code to calculate rainfall... End Function Public Sub TestCalcRainfall() Dim sUDF as string sUDF = "CalcRainfall" CustomObject.Function = sUDF ' code to run UDF End Sub Thanks, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel: Use pic location string to call up picuture in cell? | Excel Discussion (Misc queries) | |||
How do I call a dynamically created String in a VBA Sub | Excel Programming | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
sub call with string | Excel Programming | |||
Excel4 Call to get Function String | Excel Programming |