+ Reply to Thread
Results 1 to 7 of 7

Can't get tricky If command to function

  1. #1
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    748

    Can't get tricky If command to function

    Morning all,

    I wonder could anyone shed some light on my limitations: I have the following code:

    Please Login or Register  to view this content.
    The problem is activating the 5/114 variety. Is it because the name 6X0500.115 is present 2 if commands and it's choosing the first?
    It's difficult when parts share common part number. Confused

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    18,412

    Re: Can't get tricky If command to function

    What exactly is the problem.

    With If statements the order shouldn't matter, the code for the one with an expression that evaluates to true should be executed.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    748

    Re: Can't get tricky If command to function

    For some reason I cannot get the last piece of code, 6X0500.115(W/HUB 5/114) to activate. I'm not sure if its reading the first part which is similar to 6X0500115(W/HUB 5/112)?

  4. #4
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    748

    Re: Can't get tricky If command to function

    The bottom code looks fine but I can't see why it wont fire?

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    18,412

    Re: Can't get tricky If command to function

    Any chance you could upload a sample workbook?

    Click on GO ADVANCED, scroll down and click Manage Attachments.

  6. #6
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    748

    Re: Can't get tricky If command to function

    ok, I've fixed it, I had to re-arrange the request as they were too similar.

    Thank you

  7. #7
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    18,412

    Re: Can't get tricky If command to function

    It really shouldn't matter, when using = an exact match is needed.

    Anyway, as long as it's sorted.

+ 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