+ Reply to Thread
Results 1 to 2 of 2

Making a cell wording change dependant on multiple selections

  1. #1
    Registered User
    Join Date
    01-31-2017
    Location
    Manchester, england
    MS-Off Ver
    8
    Posts
    2

    Making a cell wording change dependant on multiple selections

    Hi, I'm pretty novice on Excel VBA and have been trying to work out how to make a cell value change if certain drop down responses are selected, but to no joy. I'm hoping someone can push me in the right direction.

    So I'm trying to return either Tier 0, Tier 1, Tier 2 or Tier 3 in tab 'Instructions & Glossary' cell E12

    So in tab 'Generic Information' if a user selects the following it returns Tier 0;

    C10 use existing
    C12 >4 (numbered selection up to 20)
    C13 Yes
    C14 Yes
    C22 Yes
    B31 AD / Radius Server

    or

    If a user selects the following it returns Tier 1;

    C12 >4 (numbered selection up to 20)
    C13 Yes
    C14 Yes
    C22 Yes
    B31 AD / Radius Server

    or

    If a user selects the following it returns Tier 2;

    C10 use existing

    or

    If a user selects the following it returns Tier 3;

    C10 anything other than use existing
    C12 <4 (numbered selection up to 20)
    C13 anything other than Yes
    C14 anything other than Yes
    C22 anything other than Yes
    B31 anything other than AD / Radius Server

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Making a cell wording change dependant on multiple selections

    Probably easier to do this by formula. Something like this -

    Please Login or Register  to view this content.
    Martin

+ 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. Multiple comboboxs making unique selections from same data
    By LanceNZ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2016, 08:49 PM
  2. 3 dependant drop down lists & one autofill based on those selections
    By claire_wilson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2013, 06:59 PM
  3. [SOLVED] If statement if cell x is <12 add this wording, if cell y is =>12 add this wording
    By Triscia in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-06-2013, 01:41 PM
  4. Replies: 1
    Last Post: 06-14-2012, 04:12 PM
  5. Making multiple selections from Excel drop down lists
    By Andyroo in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-16-2006, 10:25 PM
  6. Cell wording should change if result is +ve or -ve
    By karambos in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2006, 06:35 PM
  7. Change the color of a cell change dependant on a result
    By KFEagle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2005, 10:06 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