Error handling input to a Date variable

Debaser · #2 04-04-2022, 07:13 AM

I would handle the first three separately with a temp variable:

Code:

tempInput = InputBox("Enter the date the payment is due in format dd/mm/yyyy")
If tempinput = "" then exit sub
on error resume next
DueDate = CDate(tempinput)
on error goto 0
if duedate = 0 then 
   msgbox "Invalid date entered - please try again"
   exit sub
end if

You could also put the validation in a loop (with a counter so it's not infinite) so that it prompts to try again if an invalid date is entered.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge	Berryblue	Mail Merge	1	11-13-2014 05:36 PM
Run-time error 91 object variable or with block variable not set	JUST ME	Word VBA	4	03-25-2014 06:56 AM
Error handling in formula - suppress 'Syntax Error'	Cosmo	Word	7	02-24-2014 07:08 AM
Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM
Saveas error handling	jillapass	Word VBA	7	03-30-2012 03:24 PM