+ Reply to Thread
Results 1 to 2 of 2

If Statement help - If one item is X and another is not Y then exit sub?

  1. #1
    Registered User
    Join Date
    02-21-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    29

    If Statement help - If one item is X and another is not Y then exit sub?

    I have a userform that allows users to choose their name (cboName) and an item (cboItem) from comboboxes.

    Now, 2 specific items can only be selected from certain people

    Lets say there's ItemA, ItemB and ItemC, and the people are named Joe, Bob and John

    Now, only Bob and Joe can select ItemA or ItemC. How do I formulate If statements that prevent John from selecting ItemA or ItemC?

    Something like:

    Please Login or Register  to view this content.
    Thanks for the help

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: If Statement help - If one item is X and another is not Y then exit sub?

    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] How to make a graceful exit from FOR TO Statement with nested IF THEN
    By Granite-Granny in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2014, 01:44 PM
  2. How to exit a function and proceed to the Next statement of a For Loop
    By sugaprasad in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-07-2014, 10:41 AM
  3. [SOLVED] Compare two folder files - whether they exit or not and if exit then copy to another foler
    By sthiru in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-10-2012, 12:08 AM
  4. [SOLVED] Nested Loops and Exit For Statement
    By RGrunden in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2012, 02:26 PM
  5. If Statement with a list item?
    By big_fella_andy in forum Excel General
    Replies: 4
    Last Post: 12-17-2009, 03:23 AM

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