In Excel VBA, we can write decision-making codes based on certain conditions. There are two methods to write decision-making code in Excel VBA, using the If…..Then…Else syntax or using the Select Case…End select syntax.
The syntaxes are exactly the same as VB6. You need to use both the conditional operators and the logical operators together with If…The…Else statements and Select Case statements.
If sale>1000 Then
For more information, read the articles below: