| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtered Array for Listbox
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. Ive been working this for awhile. Any assistance will be appreciated. -- Jim at Eagle |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filtered Array for Listbox
Jim at Eagle wrote:
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filtered Array for Listbox
Filter using "E", "S", "M" or "C"
-- Jim at Eagle "Paul Lautman" wrote: Jim at Eagle wrote: 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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filtered Array for Listbox
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 "Paul Lautman" wrote: Jim at Eagle wrote: 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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filtered Array for Listbox
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. -- Jim at Eagle |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtered List as Listbox RowSource | Excel Programming | |||
| Trying to count text in a filtered array using this function | Excel Programming | |||
| How to sort ListBox or Array? | Excel Programming | |||
| ListBox array | Excel Programming | |||
| Listbox and Array questions | Excel Programming | |||
Linear Mode
