Filtered Array for Listbox

[Guest]

I have 6 columns of data (A-F) on sheet 1 of workbook. The data can be
filtered from column A. The data needed to display in Listbox1 on form1 is
filtered by a selection from 4 different Checkboxes on form1. The displayed
data is from column B and will need to be sorted base on column B. The data
will grow but not exceeding 500 entries.
I’ve been working this for awhile. Any assistance will be appreciated.

 

[Paul Lautman]

I have 6 columns of data (A-F) on sheet 1 of workbook. The data can be
filtered from column A. The data needed to display in Listbox1 on
form1 is filtered by a selection from 4 different Checkboxes on
form1. The displayed data is from column B and will need to be sorted
base on column B. The data will grow but not exceeding 500 entries.
I've been working this for awhile. Any assistance will be appreciated.

What sort of filtering do the 4 checkboxes do?

 

[Guest]

Filter using "E", "S", "M" or "C"

 

[Guest]

Display in Listbox1 on Userform1 an alphabetized list of names in column B on
sheet1 where in column A the entry is equal to C, E, M or S.--
Jim at Eagle

 

[Guest]

On sheet1 range A2:F500 (Data1) is the data. In column A is the filter
criteria used by 4 checkboxes on userform1. When user selects checkbox1 then
I need listbox1 to display, for selection, an alphabetized filtered list from
Data1 listing only the names in column B that match the criteria in column A.