View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Paul Doucette Paul Doucette is offline
external usenet poster
 
Posts: 40
Default "Continue?" Message Box

On Sunday, July 17, 2016 at 4:30:46 PM UTC-4, Paul Doucette wrote:
I have code that runs when a command button is triggered, that does several things, including saving the file.
After that command button is triggered, and before the existing code runs, I would like to have a message box pop up as a warning with the option to either cancel or proceed, if any of the values on the worksheet €˜Start in cells B1, B2, B3, B4, B5, B7, B8, B9, and B10 have not changed.
By that I mean, I would like that message box to launch if any of the following is true: B1=Customer, B2=Item, B3=Diameter, B4=Length, B5=Species, B7=Machine, B8=Contact, B9=Item #, and B10=INQ# OR OLD PO#
All of those default values in those cells need to be changed to different values before allowing the code to run. Is this doable?
Thank you in advance!
Paul


You understood (or guessed) perfectly. Thankyou Claus!!!!