:confused
i have 2 comboboxes,
comboYEAR to hold the years from 2005 to current year
comboMonth to hold the 12 months jan thru dec
a listbox to display results named -displaylist
All my worksheets are named in this fashion - dd-mmm-yyyy (eg. 23-jan-2008)
my user is allowed to select from both combos
When he selects the year combo, all the sheets the particular yyyy is displayed in the listbox
when he selects the month combo, the search is refined and only that particular month in the year is displayed
when he clicks the items displayed in the listbox,the particular worksheet opens up inthe background.
PROBLEM:
the year combo works fine but my month combo is not working well...
when I select a month in the combobox, instead of displayong sheetnames with just the selected months, all the sheets are displayed
can anyone please advise?
Any help at all will be greatly appreciated
here are my codes:
Please Login or Register to view this content.
Bookmarks