Getting things to happen in particular months

[Red over White]

I am trying to write a VBA program where actions are dependent on what the current month is. In the example below, in February, May, August or November one set of actions will happen and in the remaining months another set of actions will occur.
If the macro was run today, I would be looking for the program to be picking up on the “=11” element.
What I’m struggling what is what the correct TODAY/MONTH combination for this to happen, bearing in mind I use UK date formats. I have tried various combinations of TODAY, MONTH and DATE, with and without brackets, but have not had any success

If TODAY/MONTH combination = 2 Or 5 Or 8 Or 11 Then
One set of actions
End if
If TODAY/MONTH combination <> 2 Or 5 Or 8 Or 11 Then
Another set of actions
End if

If someone does come up with a solution, I would be grateful if they could clarify if I need to put leading zeroes in front of the single digit months in readiness for next year.

Thanks

 

[RobP]

clear.

please rename my macro from month() as thats not helping. Call it test() or something ?

 

[RobP]

you cant have a macro called month() as thats reserved for VBA commands ..

 

[Red over White]

clear.

Can I ask, in your macros somewhere, have you tried to create one called "month()" .. I ask as I see you have a "month1()".... and I'm wondering if its getting confused.

or maybe you made a UDF script somewhere called Month()

you cant have a macro called month() as thats reserved for VBA commands ..

That's it, it works when I change the name of the macros. The underlying script is fine. Thanks for you help.

 

[RobP]

glad we could help.

Rob