Hi All
Just a quick one.
Is it possible to test a string varibale for a specific format, e.g. Just say I have the an input box that ask for a date (UK Date) and assign it to a string var.
thanks,![]()
Dim dateVar as string dateVar= InputBox("Please enter the date") ' the following is what I don not know if (dateVar, "mm/dd/yyyy") = false then msgBox("Please enter a valid date") end if
mccreaso
Bookmarks