View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed[_9_] Ed[_9_] is offline
external usenet poster
 
Posts: 194
Default Pop Up Screen

Hi, Tmac. What you would want is probably a message box or a UserForm that
would collect the dates in whichever column that are equal to or greater
than today's date and less than or equal to the end of the month date.
Place the code that creates this box or form into This Workbook as Private
Sub Workbook_Open()
and it should do it for you.

HTH
Ed

"Tmac" wrote in message
...
I have an excel spreadsheet that keeps track of dates of scheduled

meetings with clients each month. Is their a routine I can write that when
you first open up the spreadsheet a pop up screen shows all the upcoming
dates within that month?

Thanks!