Hi
I have the following inputbox which returns a range selected by the user.

Set rRange = Application.InputBox(Prompt:="Please select any entry within "
_
& vbCrLf & "the row you would like to amend.", _
Title:="Select a row", Type:=8)

If however the user selects nothing and then clicks ok, an error box pops
up:-
"The formula you have typed contains an error etc".
Is it possible to have an alternative message box pop up which
would say something like - "You have not made a selection, please
try again!."
I could then redirect to the inputbox, by way of a goto.

I hope I am making sense.

Sandy