Vba with three click button help
GOOD AFTER NOON,
PLEASE MY DEAR
I am looking for Excel VBA three code counter that can count the number of expiry, EXPIRE WITHIN THE NEXT 30 DAYS list of date obtained by the name in an ROP expiry and msg box appearance if not word informed fill it at status when the name under expiry within next 30 days .
Date is now 19/09/2015
FRIST BUTTON Expiry---------------- fill back ground cell red
SECOND BUTTON EXPIRE WITHIN THE NEXT 30 DAYS----------fill back ground cell yellow
THREE SCECOND NOTICICATION …….. MsgBox("The rop licence for " & Name & " will expire in " & Diff & appearance if not word informed fill it at status when the name under expiry within next " days.", vbCritical, "Warning")
|