V
Vinod
Hi All,
I have developed a from in excel 2003 contains year dorpdown and listbox.
The list box source mapped/binded to a ragne and 'Year' dropdown has unique
years from the same range of listbox source.
My requirement is, if user selects year through 'Year' dropdown then the
list box has to refresh with selected year's data only. I tried to filter the
source data with selected 'Year' value but the listbox has been displaying
with old records i.e., still I see whole data includes hidden rows after
applying filter on source data.
I should not see the hidden rows in list box.
Is there any best method than implented or how to hide list box with hidden
rows from source range?
Please share your knowledge or thourghts in overcomeingt the issue which
will be appreciated.
Advanced Thanks,
~Vins.
I have developed a from in excel 2003 contains year dorpdown and listbox.
The list box source mapped/binded to a ragne and 'Year' dropdown has unique
years from the same range of listbox source.
My requirement is, if user selects year through 'Year' dropdown then the
list box has to refresh with selected year's data only. I tried to filter the
source data with selected 'Year' value but the listbox has been displaying
with old records i.e., still I see whole data includes hidden rows after
applying filter on source data.
I should not see the hidden rows in list box.
Is there any best method than implented or how to hide list box with hidden
rows from source range?
Please share your knowledge or thourghts in overcomeingt the issue which
will be appreciated.
Advanced Thanks,
~Vins.