I have been trying to get the right result for a few days with no success. I have a worksheet with multiple tabs which lists reports and their completion dates. I am trying to get a Userform to Popup with the reports that are due within zero to thirty days when the workbook is opened. I can get the Userform to Popup... bur I cannot seem to find a way to get any data based on the Selection criteria. I believe it is an issue with my cac in the Userform code. I have attached the workbook. Once I get the first sheet working I can doe the other 5 sheets and eventually add email notification at 10 days before due. Thank you in advance for any assistance. The userform is blank so right click to see code.
Bookmarks