I asked this in one of my earlier post but I have not got solution. Can
anyone help please?.
When I filter my rowsource of a list box which is a range. Rows that do not
meet the criteria are not hidden in the listbox display contrary to the
worksheet view. In other words, all rows are displayed in the list box which
I dont want. How can I make my list box display only the unhidden rows

Thank in advance

I suspect you didn't select the entire range when you autofiltered it. Try
that and see if it helps.

"Yomi" wrote:

> I asked this in one of my earlier post but I have not got solution. Can
> anyone help please?.
> When I filter my rowsource of a list box which is a range. Rows that do not
> meet the criteria are not hidden in the listbox display contrary to the
> worksheet view. In other words, all rows are displayed in the list box which
> I dont want. How can I make my list box display only the unhidden rows
>
> Thank in advance

Check your other post. You did get a response.

If you don't see it...

Try using google:
http://groups.google.com/advanced_se...public.excel.*

Specify enough information (author/date/subject/keywords) to limit your search
(if you want).

Yomi wrote:
>
> I asked this in one of my earlier post but I have not got solution. Can
> anyone help please?.
> When I filter my rowsource of a list box which is a range. Rows that do not
> meet the criteria are not hidden in the listbox display contrary to the
> worksheet view. In other words, all rows are displayed in the list box which
> I dont want. How can I make my list box display only the unhidden rows
>
> Thank in advance

--

Dave Peterson

Sorry i dont understand what you mean by selection of enire range.
Here is what my list box displayed after filtering my wksht list by date
criteria between 01/01/2009 and 02/02/2009
Date amount
11/11/2008 50000
01/01/2009 40000
02/02/2009 25000
03/03/2009 22000
03/05/2009 15000
12/12/2009 40000

you can see that dates after 02/02/2009 are displyed which is not required.
Is there a way to get listbox display correct information?

Thanks in advance



"Barb Reinhardt" wrote:

> I suspect you didn't select the entire range when you autofiltered it. Try
> that and see if it helps.
>
> "Yomi" wrote:
>
> > I asked this in one of my earlier post but I have not got solution. Can
> > anyone help please?.
> > When I filter my rowsource of a list box which is a range. Rows that do not
> > meet the criteria are not hidden in the listbox display contrary to the
> > worksheet view. In other words, all rows are displayed in the list box which
> > I dont want. How can I make my list box display only the unhidden rows
> >
> > Thank in advance

Thanks Dave. You are correct. i got the solution from an earlier post.
It worked

"Dave Peterson" wrote:

> Check your other post. You did get a response.
>
> If you don't see it...
>
> Try using google:
> http://groups.google.com/advanced_se...public.excel.*
>
> Specify enough information (author/date/subject/keywords) to limit your search
> (if you want).
>
> Yomi wrote:
> >
> > I asked this in one of my earlier post but I have not got solution. Can
> > anyone help please?.
> > When I filter my rowsource of a list box which is a range. Rows that do not
> > meet the criteria are not hidden in the listbox display contrary to the
> > worksheet view. In other words, all rows are displayed in the list box which
> > I dont want. How can I make my list box display only the unhidden rows
> >
> > Thank in advance
>
> --
>
> Dave Peterson
> .
>