I am using the following VBA code to prompt for the Month End Date th
user is working on.

Dim monthenddate As String
Dim monthendname As String
monthenddate = Application.InputBox("Enter month end date ex-03-31-06
")
monthendname = Replace(monthenddate, "-", "")
If monthendname = "" Then GoTo done
If monthendname = False Then GoTo done

What would be the VBA code to verify the date the user enters is
month end date? In other words, they are entering 7-31-06, not 7-30-0
or 7-18-06.

Thanks for your help. mikebur

--
mikebur
-----------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...fo&userid=2458
View this thread: http://www.excelforum.com/showthread.php?threadid=56266