Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Duplicate declaration in current scope" during edit and continue | Excel Programming | |||
"Continue" and Exit with For Loops | Excel Programming | |||
Change default in input box from "20" to "000000"? Have macro continue on to name sheet tab? | Excel Programming | |||
Deleted the pivot table - continue to get the "overlap" error message | Excel Discussion (Misc queries) | |||
Automatically click "Update Links" & "Continue" | Excel Programming |