VBA: How to check if the time format is correct?
<p>I want the macro to know if the time format is correct or not. For example, if the format that I want is "hh:mm:ss" and the value of <code>Selection.Text</code> is "01:10:20" then <code>Msgbox True</code> else if the value of <code>Selection.Text</code> is "01:20:0" or any value that is not match on the "hh:mm:ss" format then <code>Msgbox False</code>. Is there a way to do that?</p>