I'd like to have a message box appear when I run a macro that asks me if I want to use overdue OR due today OR due tomorrow OR due this week OR due this month.
Depending on the selection I'd like the macro to then filter a report in a certain way. I've created a YesNoCancel message box already and the code looks like this:
iReply = MsgBox(Prompt:="Do you wish to use ALL the data (else macro will use this month's data)?", _
Buttons:=vbYesNoCancel, Title:="Past Dates Breakdown")
If iReply = vbYes Then
ActiveSheet.Range("$A$2:$BG$1500").AutoFilter Field:=25, Criteria1:=Array( _
"Deployment South", "Site Share South", "Special Coverage South"), Operator:= _
xlFilterValues
ElseIf iReply = vbNo Then
ActiveSheet.Range("$A$2:$BG$1500").AutoFilter Field:=25, Criteria1:=Array( _
"Deployment South", "Site Share South", "Special Coverage South"), Operator:= _
xlFilterValues
ActiveSheet.Range("$A$2:$BK$1500").AutoFilter Field:=6, Criteria1:="<>"
Else 'They cancelled (VbCancel)
Exit Sub
End If
How could I change this to allow me to select one of the 5 options I mentioned at the top? Checkbox?
Bookmarks