Macro Runs Selection is Made from Validation List

[jadown]

I need some help here. This macro worked for me but when I try to change the cell reference (ex: "F36" to "F35") the macro doesn't work when "Yes,No, or N/A" is selected. Can someone please help me. Thanks! The "Yes, No, or N/A" is a validation list that I used.


<Code>
Sub OffshoreInput2()

If Worksheets("O & M").Range("F35") = "Yes" Then
Worksheets("Offshore_Input").Range("M36:M37").Interior.ColorIndex = 4
End If

If Worksheets("O & M").Range("F35") = "No" Then
Worksheets("Offshore_Input").Range("M36:M37").Interior.ColorIndex = 1

End If

If Worksheets("O & M").Range("F35") = "N/A" Then
Worksheets("Offshore_Input").Range("M36:M37").Interior.ColorIndex = 0

End If


End Sub
</code>

[jadown]

I need some help here. This macro worked for me but when I try to change the cell reference (ex: "F36" to "F35") the macro doesn't work when "Yes,No, or N/A" is selected. Can someone please help me. Thanks! The "Yes, No, or N/A" is a validation list that I used.

Please Login or Register  to view this content.

[jadown]

Nevermind I found my error.