Visual Basic for Applications Reference
CallByName Function
See Also Example Specifics
Executes a method of an object, or sets or returns a property of anobject.
Syntax
CallByName(object*, procname, calltype,[args()]*)
The CallByName function syntax has these named arguments:
| Part | Description |
| object | Required; Variant (Object). The name of the object on which the function will be executed. |
| procname | Required; Variant (String). A string expression containing the name of a property or method of the object. |
| calltype | Required; Constant. A constant of type vbCallType representing the type of procedure being called. |
| args() | Optional: Variant (Array). |
Remarks
The CallByName function is used to get or set a property, or invoke a method at run time using a string name.
In the following example, the first line uses CallByName to set the MousePointer property of a text box, the second line gets the value of the MousePointer property, and the third line invokes the Move method to move the text box:
CallByName Text1, "MousePointer", vbLet, vbCrosshair
Result = CallByName (Text1, "MousePointer", vbGet)
CallByName Text1, "Move", vbMethod, 100, 100