Thread: How do I test for the first character
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevlar[_3_] Kevlar[_3_] is offline
external usenet poster
  
Posts: 1
Default How do I test for the first character

This got it to work:

If Target.Address = "$D$22" Then
If Range("D18").Value = 1 Then
If Mid((Range("D22")), 1, 1) = "A" Then
Checktool.Show
End If
End If
End If

Thank

--
Kevla
-----------------------------------------------------------------------
Kevlar's Profile: http://www.excelforum.com/member.php...nfo&userid=723
View this thread: http://www.excelforum.com/showthread.php?threadid=26522

Reply With QuoteReply With Quote