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 John wants to display an error message if there is no input value. You suggest that John ____.
A) use another programming language
B) display a message up front informing the user to enter a value
C) use a Message statement
D) use an Else statement

Question

Quizplus · Accepted Answer

John should use an Else statement to display an error message when there is no input value. The updated code would look like this:

If IsEmpty(divisor) then 
    'Input field is empty so display error message
    MsgBox "Please enter a value." 
Else 
    'Input field has a value so continue 
    result = 100 / divisor 
End If

This will prompt the user to enter a value if they have not already and prevent the program from attempting to divide by zero.

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