How to find default property for particular object.
in [Programming]
|
Prev: Faxing from Excel?!
Next: VBA Editor Menu
From: Alojz on 21 Apr 2010 16:37 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
From: Mike H on 21 Apr 2010 16:51 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
From: Alojz on 21 Apr 2010 17:10 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
From: Mike H on 21 Apr 2010 18:14 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
From: Alojz on 21 Apr 2010 18:29
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 |