View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Skewes John Skewes is offline
external usenet poster
 
Posts: 6
Default 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