What are properties of Application.Caller?

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.
 
R

Rick Rothstein

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top