I have an issue with an inputbox when either user leaves blank or cancel. I tried to work a little with some if's but has so far failed miserably, please have a look and guide me in the right diretion.
Idea is that when the workbook is opened, then an inputbox ask for the date, this is then to be inserted in two cells and also be the name of the new sheet that is inserted if, and only if, a DATE is entered in the inputbox.
Sub GetDate() 'Ask for a date for the new report, insert a new sheet and insert the
'date in "B4", "D77" and name sheet with date.
Dim FormDate As Date
FormDate = InputBox("Which Date to use?", "Form Date", Date)
If FormDate = True Then
Range("B4") = FormDate
Range("D77") = FormDate
ActiveSheet.Name = FormDate
If FormDate = False Then