Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I need to display changing cell values in another cell. | Excel Worksheet Functions | |||
How do I have a data table display cell names rather than values? | Excel Worksheet Functions | |||
display values in cell | Excel Discussion (Misc queries) | |||
display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
How to display cell values in wordarts? | Excel Discussion (Misc queries) |