Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find default property for particular object.
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find default property for particular object.
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" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find default property for particular object.
Range actually has dozens of properties and defaults for those properties.
Each Object has many properties and defaults. You need to be a bit more specific on which defaults you are asking about. If you just want the .value property... msgbox object.value -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Alojz" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find default property for particular object.
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. "Gary Brown" wrote: Range actually has dozens of properties and defaults for those properties. Each Object has many properties and defaults. You need to be a bit more specific on which defaults you are asking about. If you just want the .value property... msgbox object.value -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Alojz" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find default property for particular object.
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" wrote: 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. "Gary Brown" wrote: Range actually has dozens of properties and defaults for those properties. Each Object has many properties and defaults. You need to be a bit more specific on which defaults you are asking about. If you just want the .value property... msgbox object.value -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Alojz" wrote: 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find default property for particular object.
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" wrote: 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" wrote: 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. "Gary Brown" wrote: Range actually has dozens of properties and defaults for those properties. Each Object has many properties and defaults. You need to be a bit more specific on which defaults you are asking about. If you just want the .value property... msgbox object.value -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Alojz" wrote: 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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find default property for particular object.
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" wrote: 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" wrote: 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" wrote: 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. "Gary Brown" wrote: Range actually has dozens of properties and defaults for those properties. Each Object has many properties and defaults. You need to be a bit more specific on which defaults you are asking about. If you just want the .value property... msgbox object.value -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Alojz" wrote: 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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find default property for particular object.
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" wrote: 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" wrote: 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" wrote: 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" wrote: 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. "Gary Brown" wrote: Range actually has dozens of properties and defaults for those properties. Each Object has many properties and defaults. You need to be a bit more specific on which defaults you are asking about. If you just want the .value property... msgbox object.value -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Alojz" wrote: 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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find default property for particular object.
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" wrote: 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" wrote: 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" wrote: 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" wrote: 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" wrote: 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. "Gary Brown" wrote: Range actually has dozens of properties and defaults for those properties. Each Object has many properties and defaults. You need to be a bit more specific on which defaults you are asking about. If you just want the .value property... msgbox object.value -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Alojz" wrote: 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 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find default property for particular object.
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. "Mike H" wrote: 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" wrote: 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" wrote: 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" wrote: 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" wrote: 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" wrote: 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. "Gary Brown" wrote: Range actually has dozens of properties and defaults for those properties. Each Object has many properties and defaults. You need to be a bit more specific on which defaults you are asking about. If you just want the .value property... msgbox object.value -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Alojz" wrote: 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 |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find default property for particular object.
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. "Alojz" wrote: 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. "Mike H" wrote: 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" wrote: 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" wrote: 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" wrote: 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" wrote: 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" wrote: 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. "Gary Brown" wrote: Range actually has dozens of properties and defaults for those properties. Each Object has many properties and defaults. You need to be a bit more specific on which defaults you are asking about. If you just want the .value property... msgbox object.value -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Alojz" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I find out property values for each control object? | Excel Discussion (Misc queries) | |||
What is default property of name object | Excel Programming | |||
How to check if an object has a certain property? | Excel Programming | |||
Strange behaviour of default property | Excel Programming | |||
How to find what object type is returned from Selection property ? | Excel Programming |