![]() |
#4
|
||||
|
||||
![]()
You've already got End sprinkled throughout that code (yuk) that does what you need, so you could simply use that again. IMO there are very few situations where that is really the best option. I'd move the validation code into a separate function that returns True if the save happens and false otherwise, then you can call that from anywhere you need it rather than having to make events public just so that you can call their code directly rather than leaving them to respond to events as they are designed.
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Standard Module, Class Module and UserForm | jpl | Word VBA | 0 | 03-14-2022 07:20 AM |
![]() |
MP1989 | Mail Merge | 3 | 09-10-2018 02:16 PM |
![]() |
trevorc | Excel Programming | 3 | 06-17-2018 09:46 AM |
![]() |
mihnea96 | Excel Programming | 2 | 08-15-2017 04:57 AM |
![]() |
spencerw.smith | Word VBA | 2 | 08-12-2014 07:56 AM |