How to find default property for particular object.

[Alojz]

Hi,
is there a way how to identify default property for given object. E.g., I
know default property for range object is value. Where can I find the default
property for other objects?
Thanks
Alojz

 

[Mike H]

Hi,

AFAIK, the only default property for an Excel object is 'value'. If an
object doesn't have a value property then it also doesn't have a default
property.

Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Alojz]

Let me clarify once again. I know, that default property for range object is
value. That is why I can write statement like: cell("B1") = 15 (that means, I
do not need to write: cell("B1").value = 15, as VBA knows from first
statement that it relates to value as default property for range object).
Now, I would like to know where to get list for other object's default
property from. For instance, what would be the default property for Worksheet
(object)? Can I find it somewhere or test it somehow?
May be Mike gave me the right answer, e.g. only possible (if any), defaul
property for any particular object is value.

 

[Mike H]

Did you read my post?

The only default property is 'Value', there are no more.

If an object; worksheet for example, doesn't have a value property then it
doesn't have a default property for you to look for or have a list of and
that applies to all objects in Excel.

The properties of object can be found in the object browser in VB editor but
once again if there is no value propery then that object has no default
property.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Alojz]

Hi Mike, yes I did read your post (and I referred to it in my later answer).
I was curious, as John Walkerbach in his book mentions default property for
object (and not mentioning anything about fact that only possible default
property can be value). Thanks for your effort and sorry I asked again. Btw,
even though I checked Notife me of replies checkbox, the notifications does
not come to my e-mail. Coul you tell me what is wrong?

 

[Mike H]

Glad I could help and thanks for the feedback. I've got a large collection of
John Walkenbach's books and I'll have to look but I'm sure he wouldn't have
suggested there are other default properties.

I found it in the knowledge base, have a look here

http://support.microsoft.com/default.aspx/kb/114857?p=1
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Alojz]

In fact, he did not suggest anything, just mentioning some objects have
default property. I was trying to google out some more info related to my
concern with no succes . Many thanks for link you have been posting. How can
I receive notification? Don't you know by any chance? Obviously, checkbox for
notifying on replies does not do its job :-(

 

[Mike H]

Like me your using the web interface and to the never ending shame of
Microsoft it's broken more often than not. Email notifications have been
broken for months and Microsoft can't be bothered to fix it
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Alojz]

At least, in the meantime I have found the way how to display the list of my
recent posts, so I can check their current status. Thanks for all your help
once again.

 

[JLatham]

As Mike H said - the response notifications have been broken since about Oct
'09 as best I can figure out, and these days even the "show recent posts"
isn't all that reliable either. These forums are becoming a crap shoot as to
what works and what doesn't.