ComboBox with Filtered Date Range

I have a UserForm (frmExisting) with a ComboBox (cmbJobs) that is initialized with values from column A in dynamic range “Job_No”. There is a date in each row in column H.
I wish to add two option buttons (optWeek and optMonth) to the form so that after opening the form (in which the combobox shows a long list of numbers) and selecting an option, the list is reduced to either all the numbers with dates within the last week or the last month.
Any help with the code would be appreciated, thanks Sandy.

File attached

Few Questions:

1. Should the combobox be filled with entire data if neither options are selected?
2. What day of week does your week start? Monday/Sunday?
3. Last Month & Last Week is always in context of current date? Or the Month/Week last data in the range falls in?

I'm headed out for the night, but will check back tomorrow.

Have a nice evening CK76, its 10.30am Friday over here.

1. Should the combobox be filled with entire data if neither options are selected? YES
2. What day of week does your week start? Monday/Sunday? SUNDAY
3. Last Month & Last Week is always in context of current date? Or the Month/Week last data in the range falls in? CONTEXT WITH CURRENT DATE.

I have had more thoughts on what I am trying achieve:
Default Option - Full List
Option 1 - 7 days previous to current date.
Option 2 - 30 days previous to current date.
Option 3 (if not too difficult) - Select Month and Year i.e December 2017.

I Change the properties of the combobox
columnscount to 8
columnswidth in properties
No RowSource in properties

Please Login or Register  to view this content.

Kind regards
Leo

Thanks Leo that worked just as I wanted it to. I may just tweak it a little so that the month and year are selected from a listbox.
Cheers Sandy