Calling a procedure with a variable

[edkuse]

Is it possible to call a procedure with a variable that is equal to the procedure name?

Example:

Call CommandButton1.Name

'the name is equal to BuildReport

Sub BuildReport()
...
End Sub

This will not work, is at all possible?

Thanks,
edkuse

 

[SpiderBear6]

I wonder if you could use the CreateObject function. I have only seen this used with Excel and Word and stuff, but maybe you could use it to create an object from the name in a string.

 

[paulbent]

If you put the sub in a class module as a public method then you could use the CallByName function.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[paulbent]

PS - did a quick search of my MSDN CD and even found a code sample!

http://support.microsoft.com/support/kb/articles/q186/1/43.asp

BTW you need VB6 for the CallByName function, it doesn't exist in earlier versions.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[edkuse]

Thank you. I think this will definitely help me.