Hey everyone...
I'm working on a macro with an inputbox and I don't want there to be
any empty boxes. I want the user to be forced to put *something* in
the boxes before the code will continue.

I'm imagining it has to go somewhere in my FOR NEXT loop...

For Each cItem In Me.Controls
If TypeName(cItem) = "TextBox" Then
'another if statement here? PLEASE HELP!!
sSPN = sSPN + cItem.Value + "-"
End If
Next cItem