Results 1 to 5 of 5

DropLists not excluding prior selections

Threaded View

Ochimus DropLists not excluding prior... 03-06-2017, 12:26 PM
JohnTopley Re: DropLists not excluding... 03-06-2017, 12:52 PM
LeoTaxi Re: DropLists not excluding... 03-06-2017, 01:04 PM
JohnTopley Re: DropLists not excluding... 03-06-2017, 01:09 PM
Ochimus Re: DropLists not excluding... 03-06-2017, 04:05 PM
  1. #1
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365 Version 2501 64-bit
    Posts
    1,465

    DropLists not excluding prior selections

    "StraightList" sheet on attached works perfectly. Any name selected in any DropList in F2 - F5 is removed from the other lists, and restores it if the name is cancelled.

    "Two Column List" sheet should do the same even through the DropLists are now in two columns (because they are still accessing the same common Range), but does not work.

    Whatever name is entered in any of the DropBoxes, the formulae removes it from the "pool" of future choices, but not from the DropLists themselves.

    Any advice, solutions or alternative approaches welcomed as ever,


    Ochimus

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Drop down lists dependent on 2 prior selections
    By Suicyco in forum Excel General
    Replies: 6
    Last Post: 04-29-2016, 05:34 PM
  2. Userform ListBox that recalls prior selections made
    By fil_oliveira in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-19-2016, 10:11 PM
  3. [SOLVED] Verify Dates Prior excluding weekends
    By jantonio in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-13-2013, 12:27 AM
  4. Verify Dates Prior excluding weekends
    By jantonio in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-09-2013, 08:06 PM
  5. Droplists
    By mqdias in forum Excel General
    Replies: 1
    Last Post: 12-06-2011, 10:13 PM
  6. Userform ListBox that recalls prior selections made
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-08-2010, 02:54 PM
  7. Replies: 1
    Last Post: 04-11-2006, 12:30 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