View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
N.F[_2_] N.F[_2_] is offline
external usenet poster
 
Posts: 65
Default Error Message in VBA



"Elise148" wrote:

If I wanted to put an error or info message in my VBA code, so that if the
person running the macro wanted to Cancel instead of Okay an input box and no
changes would be made to the excel document, how would I do that?

I'd appreciate any ideas!

Elise


Hi Elise, im as well learning VBA and little by little Im building up on my
experience, but in the past I had a similar question as you,
How about putting in your macro a code for a re-set of your inputs when a
command button is clicked withing your sheet?