how do i use IF ELSE IF FUNCTION in excel to chk more condition
You use If ElseIf in the following manner:
Sub UseIfElseIf()
With Range("A1")
If .Value = 1 Then
'do something
ElseIf .Value = 2 Then
'do something else
ElseIf .Value = 3 Then
'do something else again
''
''
''
End If
End With
End Sub
However, if there are a large number of ElseIf statements, and if the only
'true' statement is in one of the last ElseIfs's you'll find there's a speed
increase by using Case Statements (they both follow the same logic) e.g.
Sub SelectCase()
Select Case Range("A1").Value
Case 1
'do something
Case 2
'do something else
Case 3
'do something else again
''
''
''
End Select
End Sub
HTH,
John
--
The major part of getting the right answer lies in asking the right
question...
"chemnks" wrote:
i want to check code no(eg. 1,2,3,4,5) in a particular cell and for related
code match i want to display a contents from other cell
Please suggest
|