checking value in column

  • Thread starter Thread starter sals
  • Start date Start date
S

sals

I'm currently writing a program where there are the following columns
CCL# Description Tested? Successful? Notifiied(sent email
confirmation)? Testers (First Name) Testers (Last Name) Comments


I want to check if the tested and successful column
(right now, they have a drop down list to choose between yes and no)
I only know how to do that in one cell with this:

Sub Yes()
Sheets("Sheet1").Select
If Range("C5").Value = "Yes" Then
MsgBox "Yes."
End If
End Sub


I dont' know how to choose for a range say if c5 and c6 has yes
then...
 
Sub Yes()
Sheets("Sheet1").Select
If lcase(Range("C5").Value) = "yes" and _
lcase(Range("C6").Value) = "yes" Then
MsgBox "Yes."
End If
End Sub
 
Back
Top