Prev: Critique a function to convert time, please
Next: Limits in SQL query
From: AZSteve on 29 Apr 2010 20:10
Using VBA I want an If/Then statement to search within a single cell (D59) to
find if the ":" (colon character) exists after the fourth character. If not
"Then: Wrong = True"

In an adjacent worksheet cell I could just enter =iserr(find(":",D59,4)) and
if the result is True then I know it doesn't exist.

How do I write this in VBA?
From: B Lynn B on 29 Apr 2010 20:23
If Instr(5, Range("D59"), ":") > 0 then Wrong = True

"AZSteve" wrote:

> Using VBA I want an If/Then statement to search within a single cell (D59) to
> find if the ":" (colon character) exists after the fourth character. If not
> "Then: Wrong = True"
>
> In an adjacent worksheet cell I could just enter =iserr(find(":",D59,4)) and
> if the result is True then I know it doesn't exist.
>
> How do I write this in VBA?
From: B Lynn B on 29 Apr 2010 20:46
Dang, I really need to learn to read the details more carefully before
posting my reply. This actually should have been:

If InStr(5, Range("D59"), ":") = 0 Then Wrong = True

or

If Not InStr(5, Range("D59"), ":") > 0 Then Wrong = True

but you probably got the idea anyhow...


"B Lynn B" wrote:

> If InStr(5, Range("D59"), ":") > 0 then Wrong = True
>
> "AZSteve" wrote:
>
> > Using VBA I want an If/Then statement to search within a single cell (D59) to
> > find if the ":" (colon character) exists after the fourth character. If not
> > "Then: Wrong = True"
> >
> > In an adjacent worksheet cell I could just enter =iserr(find(":",D59,4)) and
> > if the result is True then I know it doesn't exist.
> >
> > How do I write this in VBA?
 | 
Pages: 1
Prev: Critique a function to convert time, please
Next: Limits in SQL query