start code if today is monday or saturday

[sal21]

I need to start a code if this condition is true:

if today is monday or saturday or ... then
call mycode
end if

i think is podssible also with select case, or not?

[HansV]

You can use

Code: Select all

    Select Case Weekday(Date)
    Case 2, 7 ' Monday / Saturday
        ' Do something
    Case Else
        ' Do something else
    End Select

[sal21]

You can use

Code: Select all

    Select Case Weekday(Date)
    Case 2, 7 ' Monday / Saturday
        ' Do something
    Case Else
        ' Do something else
    End Select

before you post and i read your solution...

If Weekday(Date) = vbTuesday Or Weekday(Date) = vbThursday Then
Call mycode
End If

wath you think about?

[HansV]

That's fine too.