+ Reply to Thread
Results 1 to 6 of 6

How to Simplify Multiple IF Conditions in VBA Code.

  1. 05-10-2016, 02:20 AM #1
    zaska is offline
    Forum Contributor
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    454

    How to Simplify Multiple IF Conditions in VBA Code.

    Hello,

    I have the following code, but I am seeking advice from members to simplify it further. Just out of curiosity to learn different alternatives.

    Please Login or Register  to view this content.

    Thank you
    Reply With QuoteRegister To Reply
  2. 05-10-2016, 02:34 AM #2
    spitfireblue is offline
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: How to Simplify Multiple IF Conditions in VBA Code.

    Maybe this:

    Please Login or Register  to view this content.
    Or this:
    Please Login or Register  to view this content.
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.
    Reply With QuoteRegister To Reply
  3. 05-10-2016, 02:43 AM #3
    zaska is offline
    Forum Contributor
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    454

    Re: How to Simplify Multiple IF Conditions in VBA Code.

    Thank you.

    Is it possible to use Single Line If Condition or Like Operator?
    Reply With QuoteRegister To Reply
  4. 05-10-2016, 02:54 AM #4
    zaska is offline
    Forum Contributor
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    454

    Re: How to Simplify Multiple IF Conditions in VBA Code.

    I tried

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 05-10-2016, 03:08 AM #5
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: How to Simplify Multiple IF Conditions in VBA Code.

    Try
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 05-10-2016, 03:13 AM #6
    zaska is offline
    Forum Contributor
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    454

    Re: How to Simplify Multiple IF Conditions in VBA Code.

    Thank you very much Sir.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Simplify code
    By KBSH in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2016, 03:20 PM
  2. [SOLVED] Simplify VBA Code
    By Sky188 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-28-2012, 02:31 PM
  3. [SOLVED] How can I simplify this code?
    By etuckram in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-26-2012, 05:04 AM
  4. How to simplify Criteria Conditions for DGET formula
    By Loretty2k in forum Excel General
    Replies: 4
    Last Post: 06-14-2012, 04:08 AM
  5. Simplify formula to allow more conditions
    By rennox2605 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-19-2010, 12:01 PM
  6. Code for Multiple If conditions
    By Raushan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2007, 08:23 AM
  7. Need to simplify code
    By alexwren in forum Excel General
    Replies: 7
    Last Post: 08-15-2006, 03:07 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1