Good afternoon
Once again im grateful for everyone participating in this forum. you are all the best and thanks for always helping.
i have a textbox already configured to show the system date. so everyday when u open the date will change.
we always get certain documents where there is a date stamp and then u have to manually calculate 90 days from there.
if it is 90 days and more then the clearance paper expired, then u must apply for a new one.
so i want when i open the userform, enter the date on the "clearance" it must tell me how many days have lapsed and if more than 90 days from that date
show "Expired" on a label i created.
i attaching the file where i already put some vba codes
i managed to have the days calculated.
however if the days you enter the date and it must be a date before todays date, then only when the days reach 90 and more it must show "Expired" in the label
i already created the label. i just need help with the coding
Bookmarks