How to identify todays day, not date?

[Todd_M]

Hi-

Private Sub CommandButton2_Click()
If today = Tuesday Then
MsgBox "OK"
End If
End Sub

How do you write a code that tells what today's day is, so that if today is Tuesday, then a msgbox pops up?

 

[Juan Pablo González]

On 2002-04-09 15:59, Todd_M wrote:
Hi-

Private Sub CommandButton2_Click()
If today = Tuesday Then
MsgBox "OK"
End If
End Sub

How do you write a code that tells what today's day is, so that if today is Tuesday, then a msgbox pops up?

Some options:

If Weekday(Date,vbMonday) = 2 then

or

If Format(Date,"ddd") = "tue" then

or

If Format(Date,"dddd" = "tuesday" then

 

[Todd_M]

Thanks Juan