J
Joe User
How do I find the properties/methods of Application.Caller?
When I type a period after that, there are no hints, even though I have Auto
List Members selected in Editor options, and the VBA editor does provide
hints when I type Application, for example, while I am typing.
When I open Object Browser and enter "caller" (without quotes) in the search
field, I find Caller in the list of Application members. But there is
nothing (like Range) to click on next to "Property Caller" in the lower pane
to expand the definition.
I know about Caller.Address and Caller.Worksheet.Name. I would like to
learn the other properties.
Caller seems to have some/all of the properties of Range. But I would still
like to know how to learn that other than empirically.
I am using Excel 2003 SP3 with VBA 6.5.1024.
When I type a period after that, there are no hints, even though I have Auto
List Members selected in Editor options, and the VBA editor does provide
hints when I type Application, for example, while I am typing.
When I open Object Browser and enter "caller" (without quotes) in the search
field, I find Caller in the list of Application members. But there is
nothing (like Range) to click on next to "Property Caller" in the lower pane
to expand the definition.
I know about Caller.Address and Caller.Worksheet.Name. I would like to
learn the other properties.
Caller seems to have some/all of the properties of Range. But I would still
like to know how to learn that other than empirically.
I am using Excel 2003 SP3 with VBA 6.5.1024.