Hi,

You could do this

Sub surface()
Response = InputBox("Input a number 1", "Input")
If Response = 1 Then Exit Sub
'do things
End Sub

Mike

"Eric S" wrote:

I have a macro that pops up a message box asking the user for an
number input. I want to have the macro run for all inputs greater
than 1. If the user puts in "1", I want to have the macro just ignore
it and do nothing. Is that possible with an if statement? Is that
the best way?

If the user doesn't input "1", I want the macro to do the normal
operations it was coded to do.

Any thoughts? Some code as an example would help greatly since I'm
new with VBA.

Thanks!