IF function to compare today's date with specific month [VBA]

[Martin_H]

Hello,

I am looking for an IF macro that will compare today's month with a specific month.

This macro will be at the beginning of a larger macro.

So IF today's month is < than month August then stop the whole macro and give message box "Not ready yet!"
ELSE run the bigger macro.


Thank you.

 

[Fluff]

How about

   If Month(Date) < 8 Then
      MsgBox "not yet"
      Exit Sub
   End If

 

[Martin_H]

Awesome, thank you Fluff.

 

[Fluff]

You're welcome & thanks for the feedback.