display values in cell
I am new to Excel VBA but quite comfortable with Access
VBA.
I would like to enter a value in cell C1 based on the
following conditions
If the value in A1 is < 90 then display OK in B1
If the value in A1 is 100 display Overdue in B1
If the value in A1 is between 90 and 100 print Notice in
B1
This is what I have but it is not working
Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
Dim celA1 As Integer
Dim celB1 As String
celA1 = Range("A1:A1")
celB1 = Range("B1:B1")
If celA1 < 90 Then
celB1 = "OK"
ElseIf celA1 100 Then
celB1 = "Overdue"
Else
celB1 = "Notice"
End If
End Sub
Thanks for any help
|