input box to not allow blanks

[moxy85]

I've got a set of input boxes which collect information from the user,

how can I make it so that the input boxes MUST have data entered before allowing the user to progress to the next box?

Thanks in advanced.

 

[repairman615]

Hello,

Does this help?

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> i()<br><br><SPAN style="color:#00007F">Dim</SPAN> a<br><SPAN style="color:#00007F">Dim</SPAN> b<br><br><br>aRestart:<br>    a = InputBox("a", "A", "a")<br>    <SPAN style="color:#00007F">If</SPAN> a = "" <SPAN style="color:#00007F">Then</SPAN><br>        MsgBox "A must be entered"<br>        <SPAN style="color:#00007F">GoTo</SPAN> aRestart:<br>    <SPAN style="color:#00007F">Else</SPAN><br>        MsgBox a<br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br><br>bRestart:<br>    b = InputBox("b", "B", "b")<br>    <SPAN style="color:#00007F">If</SPAN> b = "" <SPAN style="color:#00007F">Then</SPAN><br>        MsgBox "B must be entered"<br>        <SPAN style="color:#00007F">GoTo</SPAN> bRestart:<br>    <SPAN style="color:#00007F">Else</SPAN><br>        MsgBox b<br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br><br><br><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>