Excel Userform Popup Notification

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.

Hello mwo,

Welcome to the Forum!

Since your UserForm is blank, what information did you want to display on it?

Do you need to search for records and edit them?

Hello mwo,

So, you want to display list of the reports due like a message box would?

I don't see any column labeled Due Date.

What range on what sheet should one be looking at to determine which reports to put in the pop-up?
What do you want the pop-up to read just a list of report numbers or other data?
Aprox. how many reports do you expect this to show?

Is there a particular reason that you prefer a userform to a MsgBox?

Using the VBA editor you should be able to access the code I have on userfrom1 in the workbook I attached. Let me know I can always upload again.. I need a report for each sheet. starting with sheet2. However I was developing the userform for sheet5, (sheet5 just happens to be the 2nd sheet in the workbook). But same applies for Sheet2 thru sheet5. I did not want to necessarily bother anyone to develop the entire thing. If I can get one sheet to work, I probably can modify to get the other sheets up and running.So to answer your question at this time I was planning on 4 reports. Range is on sheet5 starting at row 4, column 4. On the userform1 code as follows:

Please Login or Register  to view this content.

No particular reason, just thought if I planned to modify later for selection or email it might be easier.

Thanks, I hope I am not being too stupid here.

That code looks like it should work, one there is a listbox in the userform.

There is no place in the userform for the data to be shown.
Put some controls in the userform and load the data into them.