I’m trying to force the user to provide an answer to an input box by using a while loop. I have
While isBlank(sAnswer) 'Force the user to enter something for a reason for rejecting a data set. sAnswer = InputBox("What is the reason for rejecting the data set?", "Question:") sAppend = " - " & sAnwer Wend
The line starting with “While” keeps throwing:
BASIC runtime error.
Sub-procedure or function procedure not defined.
I have no idea what’s wrong. I think my why loop follows the syntax on the help page for while…wend