如何在VBA中的语句中使用WEEKNUM函数？ [英] How can I use the WEEKNUM function in a statement in VBA?

问题描述

我想编写一个VBA，检查WEEKNUM或ISOWEEKNUM是否等于该值，然后运行其余的宏。我尝试这样做，但是由于使用TODAY作为arg而出现错误。

I want to write a VBA, to check if WEEKNUM or ISOWEEKNUM equal to the value, then run the rest of macro. I've tried to do that but I got an error because of using TODAY as arg.

推荐答案

这是一种使用方法在VBA中都是 WEEKNUM（）和 TODAY（）：

Here is one way to use both WEEKNUM() and TODAY() in VBA:

Sub dural()
    If Evaluate("=weeknum(today())") = 28 Then
        MsgBox 28
    Else
        MsgBox "not 28"
    End If
End Sub

这篇关于如何在VBA中的语句中使用WEEKNUM函数？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！