Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Configuring Help in VBA Editor 2010

  1. #1
    Board Regular BrighterLater's Avatar
    Join Date
    Sep 2005
    Location
    Maidstone, UK
    Posts
    112
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Configuring Help in VBA Editor 2010

    I've just started using VBA in 2010. In earlier versions of the VBA editor you just highlighted something and hit F1 and you got Help. Now when I do that I get an online webpage offering me a choice of:
    * Excel 2010 Developer Reference
    * Visual Basic for Applications Language Reference for Office 2010
    *Object Library Reference for Office 2010
    If I drill down I just get more options but no useful help, (and at 67 I wonder why I'm not sitting in a deckchair soaking up the sun.)
    Searching for help on help is minefield because the search can be interpreted in so many ways, within Excel, within VB, producing help within ones code etc.

    Please can someone tell me how to configure things so that F1 in the VBA editor gives me direct help. Thank you
    Mike H

  2. #2
    Board Regular
    Join Date
    Dec 2011
    Posts
    3,638
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Configuring Help in VBA Editor 2010

    Hi Mike

    In the help page that opens (when you hit F1) in the bottom right corner can you see a button that probably says something like "Office Online" or some such value? Click this and change it to "Show Content From This Computer Only", then retry
    For testing your Regular Expression patterns, try my Regular Expression Pattern Testing add-in!

    For notes on how to use it - see here.

  3. #3
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Configuring Help in VBA Editor 2010

    At the bottom right of the Help window click the icon and select "Show content only from this computer".
    HTH, Peter
    Please test any code on a copy of your workbook.

  4. #4
    Board Regular BrighterLater's Avatar
    Join Date
    Sep 2005
    Location
    Maidstone, UK
    Posts
    112
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Configuring Help in VBA Editor 2010

    Thank you both. One wonders how the designer of that webpage should think that that was intuitively obvious. It's in the category of "everything is simple when you know the answer". I can now carry on (and the deck chair is going to be empty for a bit longer.)

    Thanks - Mike
    Mike H

  5. #5
    Banned user
    Join Date
    May 2014
    Location
    Germany
    Posts
    1,336
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Configuring Help in VBA Editor 2010

    >>>>>>>>>>>>
    " select "Show content only from this computer". "
    THanks, Danke... ... That just did the trick for me as well!!!
    Alan
    Germany

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •