View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AZSteve AZSteve is offline
external usenet poster
 
Posts: 31
Default Search within a single cell for a character

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?