+ Reply to Thread
Results 1 to 3 of 3

VBA - how to install

  1. #1
    Forum Contributor
    Join Date
    08-22-2005
    Location
    Denmark
    MS-Off Ver
    Excel 365
    Posts
    349

    VBA - how to install

    "Need help with VBA!!!!!!!!!!!!!!" - a typical useless thread title, but in this case I mean it literally (exept for the exclamation marks). I've been given a new computer with new installations and it does not give explanations to all my searches in the Help-file.
    Example: Search for "else" and get 100 hits. Three of them will be about "using if-then-else", but further clicking on those three gives nothing.
    I remember vaguely to have seen once that you must download or add-in some of the Help-file for VBA, but I don't rembember how. Can someone please give a quick hint?

    NSV

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good morning nsv

    I just did a search on Help (Excel 2003) for "else", and the second item on the list was the If...Then...Else statement. I think you might be looking in the wrong place. From Excel press Alt + F11 to open up the VBE, then search for help from there.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Forum Contributor
    Join Date
    08-22-2005
    Location
    Denmark
    MS-Off Ver
    Excel 365
    Posts
    349
    Oh, but that is actually where I am when searching for help.
    I press F1 or click Help on the Visual Basic Tools - not on the Excel Tools - and then I write "else". This gives a list of 100 hits which in turn must be clicked on one at a time to get the details from the actual page in the Help-file. The problem is that nothing comes up when I click those hits that definitely describes the use of "If...Then...Else". Only hits which by coincidence contain an example with an If-Then-Else construction open a page.
    It is as if a certain part containing basic rules is missing from the Help-file, and I think I've read or heard something about it being necessary to download something from somewhere to get the complete VBA Help-file, but perhaps I am confusing this with another set-up - it is a long time ago...

    NSV

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1