+ Reply to Thread
Results 1 to 6 of 6

Can't execute an Other Than command

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

    Can't execute an Other Than command

    Morning All,

    I have the code below which activates a correct message when two variables are satisfied. That is, the combination of "X" with "4/139" or "4/100".


    However, is it possible to have an error message which is called if X is combined with anything other than "4/139" and "4/100". This would save a lot of time compared to putting all incorrect combinations.




    Please Login or Register  to view this content.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Can't execute an Other Than command

    Please Login or Register  to view this content.

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

    Re: Can't execute an Other Than command

    That's great thanks. However, can this be modified to omit the first part "correct" and only call error message if the two variables are not matched? Thanks for your help

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

    Re: Can't execute an Other Than command

    Some thing like this, I don't know the command for do nothing lol


    Please Login or Register  to view this content.

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

    Re: Can't execute an Other Than command

    Some sort of proceed/continue instruction?

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

    Re: Can't execute an Other Than command

    I've got it, just leave blank. Thanks for help


    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] I cannot execute my case command?
    By bralew in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2016, 09:47 AM
  2. [SOLVED] Command button will not execute all the time
    By fluce in forum Excel General
    Replies: 3
    Last Post: 10-02-2012, 04:51 PM
  3. Using macro to execute a command in Shell Command
    By aadarsh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2010, 07:06 PM
  4. A vba code command does not execute as it should...
    By Stu M in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2009, 11:07 PM
  5. execute keystroke command
    By Smed in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2007, 08:57 AM
  6. Execute a ping command
    By Significent in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-21-2005, 09:30 PM
  7. [SOLVED] VBA Equivalent of ASP 'Execute' Command
    By The Vision Thing in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-06-2005, 07:06 PM

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