Gallery
Excel - Power Query - Power Pivot - VBA
Share
Explore
Gallery
Excel - Power Query - Power Pivot - VBA
Visual Basic

icon picker
Décisions

If Then

Sur une seule ligne :
If condition Then instruction:instruction
Sur plusieurs lignes (préférable) :
If condition Then
instructions
ElseIf condition Then
instructions ...
ElseIf condition Then
instructions ...
Else
instructions
End If

Select Case

Select Case testexpression
Case expressionlist
instructions
Case Else
instructions
End Select
Expressionlist peut avoir comme valeur :
1, 2, 10
1 To 5, 10 To 20
Is > 10
Gallery
Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.