View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric S[_2_] Eric S[_2_] is offline
external usenet poster
 
Posts: 4
Default If statement question

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!