Value LIKE
Maybe: If ActiveCell.Value Like "*:*"
"Pyrite" wrote:
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
|