Question part 1. The book VBA and Macros for Microsoft Office Excel 2007, by Bill Jelen and Tracy Syrstad, and the same books for 2010, both say to install the VBA help files. How do I do that?
I have an original Office 2010 disk, and I don't see that feature on the custom installation menu.
Question Part 2. I'm trying to access the help topic for the word End in my VBA code. When I press F1, it brings up Context Help menu, and then asks if I want to use VBA library End object, or Excel library End object.
When I click on VBA library, the help topic from online comes up exactly as in the book. As stated in the book, this is not the correct help topic.
When I click on Excel VBA library, the help topic from online brings me to a menu that asks which category that I'm interested in.
I'm trying to find the help topic for Range.End Property. But I can't find that topic anywhere in the online help topics.
Also, I only know that is the topic I'm looking for because that's what's listed in the book.
I'm looking for the way to put the cursor on the word "End," press F1, then choose Excel library, and have the same help topic come up as it shows in the book. For Range.End Property, as on pages 41-42 of the 2007 version of the book. Exact same instructions in the 2010 book.
Thanks.
"During reinstall, select the custom install and be sure to select the VBA help files."
I have an original Office 2010 disk, and I don't see that feature on the custom installation menu.
Question Part 2. I'm trying to access the help topic for the word End in my VBA code. When I press F1, it brings up Context Help menu, and then asks if I want to use VBA library End object, or Excel library End object.
When I click on VBA library, the help topic from online comes up exactly as in the book. As stated in the book, this is not the correct help topic.
Excel Developer Home > Visual Basic for Applications Language Reference for Office 2010 > Visual Basic Language Reference > Statements
End Statement
This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.
Ends a procedure or block.
When I click on Excel VBA library, the help topic from online brings me to a menu that asks which category that I'm interested in.
Categories
Excel 2010 Developer Reference
Visual Basic for Applications Language Reference for Office 2010
Object Library Reference for Office 2010
I'm trying to find the help topic for Range.End Property. But I can't find that topic anywhere in the online help topics.
Also, I only know that is the topic I'm looking for because that's what's listed in the book.
I'm looking for the way to put the cursor on the word "End," press F1, then choose Excel library, and have the same help topic come up as it shows in the book. For Range.End Property, as on pages 41-42 of the 2007 version of the book. Exact same instructions in the 2010 book.
Thanks.
Last edited by a moderator: