VBA Test For Valid Number Format
Posted on 2016-09-21
I am looking for a function that when passed a number format as a string (e.g. "mm/dd/yyyy") returns True or False depending on whether the string is indeed a valid number format. Obviously "mm/dd/yyyy" is valid but "1.1.2..3kklksjlkj" is not. Does anyone have this already written up? I'm assuming this will require the use of regular expressions and I have never swam in that end of the pool.
P.S. Please do not post solutions using error checking. I know that is an option.