Results 1 to 2 of 2

Thread: Userform - Match and return criteria (2 criteria conditions)
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2018
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Userform - Match and return criteria (2 criteria conditions)

    hello. I am working on a userform in which I would like to have 2 criteria options; the 1st being a number (1-100) and the second being a choice from a drop down list. When user enters the number and selects the drop down - I would like 4 different list boxes to generate information.

    Example: User enters 55 and chooses Option C
    List Box 1 would return some choices that associate with that (recommended reading)
    List Box 2 would return some choices that associate with that (recommended videos)
    List Box 3 would return some choices that associate with that (recommended websites)
    List Box 4 would return some choices that associate with that (recommended forums)

    Each of these list boxes will have data. How do I get that data to match the choices the user makes.

  2. #2
    New Member
    Join Date
    May 2018
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Userform - Match and return criteria (2 criteria conditions)

    Number Ranges:
    1-25
    26-50
    51-75
    76-100

    Options:

    Option 1

    Option 2

    Option 3

    Option 4

    Option 5



    List box 1 List box 2 List box 3 List box 4
    Read 1 Video 1 Website A Group A
    Read 2
    Video 2 Website B Group B
    Read 3 Video 3 Website C Group C
    Read 4 Website D Group D
    Read 5
    Website E Group E
    Read 6
    Website f
    Website G
    Website H


    If user enters a number between ranges 1-25
    List box one should return “read 1, Read 2, Read 3,” Listbox 2 would return: Video 1, List box 3 would return; Website A, Website C,Website D, and List box 4 would return; Group A, Group B

    And then if user selects an option more list items shouldappear:

    List box 1 – Read 1-4, List box 2 – Video 1, List box 3 –Website A-F, List box 4 – Group A-D

    So what that would mean I believe is that every number rangewill be associated with a list box option, and every option will be associatedwith a list box option also. But, how do I get them combined? To return on auserform?


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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