Make a breakpoint at the line.Select the Object and Press Shift + F9 , object will be added in Watch Window.. you can find all assigned properties of that object
For methods , when you use DOT (.) follow by object VBE provides list of all Methods ( Green Legends ) Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Apr/Fri/2012 09:45 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ How do you find all the properties or methods of an object? Hey Howard, They are all listed in Help. Make sure to disable online help* for the help function to operate in a reasonable way and to find all the reference material. Also, make sure you have the table of contents showing. If you open Help from within the VBE Visual Basic Editor, you should have access to all the VBA and Excel object model reference material. You can either do a search, or if you look at the TOC you should see among the main entries "Excel Object Model Reference", "Visual Basic For Application Language Reference", "Object Library Reference for Microsoft Office", and "Microsoft Graph Visual Basic Reference". Those are each main libraries that contitute the VBA language as used in Excel. You can drill down through the TOC to explore the entire object model, all properties, methods, enumerations, commands and syntax. If you use early binding (declare your object variables as a specific type of object) then intellisense should provide a list of all the properties and methods if you type the variable name and then hit ".". If you type or select a method of an early-bound object, intellisense also will display the list of parameters, and for enumeration parameters, when you get to entering that parameter, provide the list of enumerated constants to choose from. re. Early/late binding, see http://peltiertech.com/Excel/EarlyLateBinding.html and http://support.microsoft.com/kb/245115 (a little mroe under-the-hood discussion than needed). Besides Help and Intellisense, there is an Object Browser that allows you to browse all referenced libraries, including of course the built-in ones described in Help. You can access the Object Browser with F2, from the View menu, or with one of the buttons on the VBE toolbar. * To disable online Help, open Help, and in the lower-right corner/status bar, if it says "Connected to Office.com", left-click and then choose "Show content only from this computer". This setting will be reatined until you change it again. I recommend only using online help as a last resort. By the way, thanks for your kind words before. I have a draft reply to the questions I had intended to answer for you, but never quite finished it. I'll have to get some kind of partial response to you anyway .. will soon I still promise :) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of tangledweb Sent: Thursday, April 05, 2012 5:57 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How do you find all the properties or methods of an object? If I want to find all the properties (if that is the correct word) for an object how do I do it? Excel help just gives simple examples. In the ones I wanted intellisense did not help. Right mouse on the word gave an option to list all properties and methods but when clicked nothing happened. For example, I want to know all the properties of activesheet such as usedrange. I want to know all the properties of usedrange such as offset. How do you find them and their usage syntax? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
