Userform - Match and return criteria (2 criteria conditions)

[katiemadady]

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.

 

[katiemadady]

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

<tbody> </tbody>

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?