Query about Input boxes

[Hottest Fudge]

Dear Excel Wizards,

I was wondering if it was possible that when you answer a input box with no answer "" and then press ok then the input box loops to ask the question again. If the user inputs nothing "", and clicks cancel or clicks the red button then the sub is exited. Or even better if the user clicks cancel it goes to previous Inputbox and if clicks red button then exits sub. In summary is it possible to code actions for when either OK, CANCEL or Red button is pressed for a VBA inputbox?


Cheers,

 

[Hottest Fudge]

I have found that the trick with vbBoolean.

Example:

Answer=InputBox(" Question?")

If VarType(Answer) = vbBoolean
Exit Sub
End If
If Answer = "" then Goto Example

Still is there anyway of differentiating between red button and cancel button?