Nested Ifs are allowed,_______.
A)But you are limited to only 4 levels of Ifs
B)But each If must have an End If
C)Can be difficult to follow if they are nested too deeply
D)Both answers b and c are correct.

Question

Quizplus · Accepted Answer

Both answer B and C are correct. Each If statement must have an End If to properly close the statement. While nested If statements are allowed, they can become difficult to follow if they are nested too deeply, making the code hard to read and maintain. Also, VBA only allows up to 20 levels of nested Ifs, beyond which it will generate an error.

Nested Ifs Are Allowed,_______