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

<tbody> [TD="width: 85, bgcolor: transparent"] List box 1 [/TD]
[TD="width: 85, bgcolor: transparent"] List box 2 [/TD]
[TD="width: 85, bgcolor: transparent"] List box 3 [/TD]
[TD="width: 85, bgcolor: transparent"] List box 4 [/TD]
[TD="width: 85, bgcolor: transparent"] Read 1 [/TD]
[TD="width: 85, bgcolor: transparent"] Video 1 [/TD]
[TD="width: 85, bgcolor: transparent"] Website A [/TD]
[TD="width: 85, bgcolor: transparent"] Group A [/TD]
[TD="width: 85, bgcolor: transparent"] Read 2 [/TD]
[TD="width: 85, bgcolor: transparent"] Video 2 [/TD]
[TD="width: 85, bgcolor: transparent"] Website B [/TD]
[TD="width: 85, bgcolor: transparent"] Group B [/TD]
[TD="width: 85, bgcolor: transparent"] Read 3 [/TD]
[TD="width: 85, bgcolor: transparent"] Video 3 [/TD]
[TD="width: 85, bgcolor: transparent"] Website C [/TD]
[TD="width: 85, bgcolor: transparent"] Group C [/TD]
[TD="width: 85, bgcolor: transparent"] Read 4 [/TD]
[TD="width: 85, bgcolor: transparent"] [/TD]
[TD="width: 85, bgcolor: transparent"] Website D [/TD]
[TD="width: 85, bgcolor: transparent"] Group D [/TD]
[TD="width: 85, bgcolor: transparent"] Read 5 [/TD]
[TD="width: 85, bgcolor: transparent"] [/TD]
[TD="width: 85, bgcolor: transparent"] Website E [/TD]
[TD="width: 85, bgcolor: transparent"] Group E [/TD]
[TD="width: 85, bgcolor: transparent"] Read 6 [/TD]
[TD="width: 85, bgcolor: transparent"] [/TD]
[TD="width: 85, bgcolor: transparent"] Website f [/TD]
[TD="width: 85, bgcolor: transparent"] [/TD]
[TD="width: 85, bgcolor: transparent"] [/TD]
[TD="width: 85, bgcolor: transparent"] [/TD]
[TD="width: 85, bgcolor: transparent"] Website G [/TD]
[TD="width: 85, bgcolor: transparent"] [/TD]
[TD="width: 85, bgcolor: transparent"] [/TD]
[TD="width: 85, bgcolor: transparent"] [/TD]
[TD="width: 85, bgcolor: transparent"] Website H [/TD]
[TD="width: 85, bgcolor: transparent"] [/TD]
</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?