I have a workbook with worksheets that are named in the format Mmm YYYY (ie Jan 2013, Feb 2013 etc) and I use my sheetnames to create a list for a dropdown based on the following form
As you can see from the last few lines of code the listbox is created from the sheetnames from 7 onwards (the 1st 6 sheets have a different naming convention and arent ones I wish to include in my listbox)
Now currently all sheets are included in the listbox but I am not interested in those sheets that exist in the past, only the sheets that are this months and future months.....how would I go about changing this?
Bookmarks