Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter of List box Rowsource
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter of List box Rowsource
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter of List box Rowsource
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter of List box Rowsource
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter of List box Rowsource
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select Dynamic list for rowsource on a list box | Excel Programming | |||
How to add different column to a list box using rowsource | Excel Discussion (Misc queries) | |||
How do I set the rowsource for a ComboBox for a dynamic list? | Excel Programming | |||
Filtered List as Listbox RowSource | Excel Programming | |||
AutoFilter _FilterDatabase Rowsource Listbox | Excel Programming |