Excel 2010 VBA - Do you use the Object Browser?
I find the object browser of limited usefulness. Am I the only one?
Some subs/methods are displayed as functions.
It doesn't make sense because a function returns a value and a sub does not.
am I wrong?
Or are there some uses for the object browser that I'm missing.
Some subs/methods are displayed as functions.
It doesn't make sense because a function returns a value and a sub does not.
am I wrong?
Or are there some uses for the object browser that I'm missing.
It's the best tool you can get to explore what is available in a library, and what are the properties and methods of each class.
And it still have a usable search mechanism, something that is missing in the last versions of the Office help.
In many instances, it's a lot faster to search in there than in online help to find the property or method that will do something you need. Once you have found it there, then F1 brings you in Help with more details.
And it still have a usable search mechanism, something that is missing in the last versions of the Office help.
In many instances, it's a lot faster to search in there than in online help to find the property or method that will do something you need. Once you have found it there, then F1 brings you in Help with more details.
ASKER
HI Martin:
Range.Activate is also a sub (method) because it does not return a value but it is listed as a function in the browser.
Or do I have a misunderstanding. (I'm still on my road to mastery!)
Range.Activate is also a sub (method) because it does not return a value but it is listed as a function in the browser.
Or do I have a misunderstanding. (I'm still on my road to mastery!)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you open the Object Browser and click on a class like 'ComboBox' it will show you all the events, properties and methods. Clicking on one of them gives helpful information.