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.

Hello,

That depends on the type of it. See
http://www.cpearson.com/excel/Return...ysFromVBA.aspx
please.

Regards,
Bernd

The properties, if any, depend on what did the calling. See the help files
for Caller Property... it has a decent description and example for it.

--
Rick (MVP - Excel)


"Joe User" <joeu2004 wrote in message
...
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.

"Rick Rothstein" wrote:
See the help files for Caller Property

Ding! Thanks.


----- original message -----

"Rick Rothstein" wrote in message
...
The properties, if any, depend on what did the calling. See the help files
for Caller Property... it has a decent description and example for it.

--
Rick (MVP - Excel)


"Joe User" <joeu2004 wrote in message
...
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.