I need a VBA code that will find a sheet "Missing Date" and
Pop up input box will open asking "Please input date".
Once the user inputs date in pop up box code should change the name of the sheet "Missing Date" to date that was inputed in pop up box. Format of the date should be for example: 10-21-12

Thank you