Hi,

I'm trying to write a line of code to test a value that has been input for
containing a :

I was thinking something similar to:

If Target.Value Like "##:##" Then

However, the like will not recognise Target.Value and as such would only
look for that eact line being entered. Any suggestions? It is to work on a
Workbook Change and basically will be If the string contains a : then Exit Sub