About Us

Hokievandal

Thanks Bob...

"Bob Phillips" wrote:

Public Function CalcRainfall(iDate As Date) As Double
'code to calculate rainfall...
End Function

Public Sub TestCalcRainfall()
Dim sUDF As String

sUDF = "CalcRainfall"

Application.Run sUDF, Date

End Sub

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Hokievandal" wrote in message
...
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
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel: Use pic location string to call up picuture in cell?	vloh28	Excel Discussion (Misc queries)	1	October 30th 07 12:42 AM
How do I call a dynamically created String in a VBA Sub	[email protected]	Excel Programming	4	December 25th 06 02:36 PM
Call Center Management: How to calculate 'cost per call'	Denniso6	Excel Discussion (Misc queries)	2	June 25th 06 05:01 PM
sub call with string	aran	Excel Programming	5	June 18th 05 05:33 PM
Excel4 Call to get Function String	Rob Bovey	Excel Programming	6	September 24th 03 06:34 PM

Menu

About Us