VBA Code displays a pop-up message if date above 20th

[Danilo Flaiban]

Hello community,

I'm needing help with some VBA coding.
I need an alert message box to appear if the date in cell S2 is above the 20th day in the month, and cells P22 and/or P24 have a value above 0,01 cents .

Thank you in advance for your help.

[BadlySpelledBuoy]

At what point do you want the message box to appear? When a value in P22 or P24 is changed, or some other trigger?

BSB

[Danilo Flaiban]

Good morning Badly ,
The message should appear if P22 and/or P24 are filled in, and , if the date in S2 is above 20th day (21 until 30/31)

[BadlySpelledBuoy]

Try this in the worksheet module.

Please Login or Register  to view this content.

It will fire each time a value is entered in P22 or P24.

BSB

[Danilo Flaiban]

Thanks a Lot , Badly


It worked very well

[BadlySpelledBuoy]

Glad I could help

BSB