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...blic.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
.