Check if textbox entry is in hh:MM format

[johncassell]

Hi all,

could someone tell me the best way to validate that the text in a textbox is in hh:MM format please using VBA..

I.e the following will not be accepted:

'john'
'123'
'12:123'
'25:25'

but this will be accepted..

'14:55'

Thanks
John

[royUK]

I woud use two comboboxes to select hours & minutes. Then combine the two in the correct format when needed.

[royUK]

Here's a quick example

[johncassell]

Brilliant, thanks Roy. Much appreciated.

John

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save