[newbe]

Hi Folks, Could someone help me out here. I've spent a huge amount of time trying to get my head around this but without any success. What I'm trying to do is to filter a worksheet for printing based on the selected month in a userform drop...

Hi Folks, Could someone help me out here. I've spent a huge amount of time trying to get my head around this but without any success.

What I'm trying to do is to filter a worksheet for printing based on the selected month in a userform drop down list. I've attached a screen capture of the two user forms used - (see "Excel Report Userform.PDF"). The first is a menu of available reports. When the Management Report is selected (button number 1) then the Report Date userform opens and the user is asked to select a reporting period.

The dates are stored as short dates in European format (dd/mm/yyyy). See attached sample "L5 Column Sample.jpg". Incidently, arrows on the column are hidden.

When the Month is selected, the index value is stored in a public variable ReportingPeriodVal. I then use a Select Case to determine the action to be taken.

Private Sub ReportPeriod_Change()

ReportingPeriodVal = ReportPeriod.ListIndex
Unload ReportDate

End Sub

Where I'm struggling is how to code the criteria for the Autofilter when the month is selected. The code below has message boxes just to test the Select Case functionality.

Select Case ReportingPeriodVal

Case 0
MsgBox " YTD: " & ReportingPeriodVal
Case 1 To 12
MsgBox "Selected Month is: " & ReportingPeriodVal
Case 13
MsgBox "Q1"
Case 14
MsgBox "Q2"
Case 15
MsgBox "Q3"
Case 16
MsgBox "Q4"
End Select

I can't attach the workbook because it contains company confidential data.

Thanks in advance
Coop

Attached Thumbnails
Attached Files Excel Report Userforms.pdf (20.7 KB)