The program compiles and runs with no errors so I assume no syntax errors. But I did the compile test anyway and no errors (or any other indication it actually did anything). Anyway you got me on the right track, thanks once again. I think you can take the rest of the night off.
On Thu, Apr 5, 2012 at 10:00 PM, Asa Rossoff <a...@lovetour.info> wrote: >> I have had intellisense work sometimes and others not so I guess I > must not have had early binding for those that failed. > > If there is a syntax error in your code it can disable intellisense too. > Debug menu > Compile will verify you have no syntax errors bugging VBA. > > > -----Original Message----- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Domain Admin > Sent: Thursday, April 05, 2012 9:31 PM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ How do you find all the properties or methods > of an object? > > Thanks much as always. I did find the object browser but was unable > to get to the next layer down on anything I found. I will try again. > I have had intellisense work sometimes and others not so I guess I > must not have had early binding for those that failed. I will read up > on it. Never would have thought of turning off the net help or even > that it was possible. > > On Thu, Apr 5, 2012 at 9:14 PM, Asa Rossoff <a...@lovetour.info> wrote: >> 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 > > -- > 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
