AC Adv Case 13-2 John has written a VBA program that uses the following IF statement. He tests the program and the IF statement is not working as expected, so he asks for your help. 'This If statement checks for an empty input value 'Then it divides 100 by that value If IsEmpty(divisor) then 'Input field has a value so continue result = 100 / divisor End If You explain that the result is not being displayed correctly because ____.
A) the code was not compiled correctly
B) the result equation is part of the comment statement above it
C) John should use the IsNull syntax
D) John cannot divide by a variable name

Question

Quizplus · Accepted Answer

John should use the IsNull syntax because IsEmpty only checks for empty strings, not null values.

AC Adv Case 13-2 John Has Written a VBA Program