Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adjacent Dependent Validation Lists (Office97 SR2)

    Hello Fellow Loungers:
    Background:
    Many of you probably already know (from my past posts) that I develop applications for monitoring the production rates and quality of Medical Record Abstractors. With this application, the client selects a user (an abstractor), picks a variable from a Validation List, and then clicks a button which activates code to bring back monthly IQC data for the user. These data include the month name, the number of times the user abstracted this variable in the IQC sample for each month, and the number of times the abstraction was correct.
    PROBLEM
    Some Variable Names are not unique (i.e., they appear multiple times but with different titles); an example would be Presence of Stroke Symptoms (where the abstractor can select any of multiple symptoms from a picks list). I was not aware of this when I designed the Application. So, I have two column lists, one with the Variable Names and an adjacent one with the Title (short description of the Variable). I use a VLOOKUP function to bring back the Variable Description to the cell adjacent to the Validation cell (the cell that is used to select the variable name). Currently, if the client selects one of these variables they get the data corresponding to the first occurrence of this variable in the list.
    QUESTION
    Is there anyway I could design this so that the client would be presented with a list of the different definitions (descriptions) of that variable, say in a 3rd adjacent column? Or, do I have to use a VBA list Box or something else?
    Thanks for your help.

    Stephen
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18> <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Adjacent Dependent Validation Lists (Office97 SR2)

    epic60sman

    many people would have many solutions, some will be great and easy, others will be cumbersome and accurate.

    I suggest you look at your data, and expand your VLookup list. I know this is the long way, but you will have the best accuracy ever.

    You could Advance Filter your data into a new location with Unique entries, then get your list that way.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •