Help with VBA to soft error on close/save if data missing from fields.

[Guitarmageddon]

Hello everyone. I have seen different approaches and code I can lift online about this, but my result is always a hard error. I want to have a popup occur on saving and/or closing if the user has not entered data into E21:E26, D2, D4:D9. There are other techniques such as conditional formatting to call their attention to these ranges, but I wanted to have a soft error popup come up to say "You are about to close and/or save this sheet without important data entered into XYZ fields, please go back and confirm" But at the same time, I dont want it to send them in a loop of not being able to save or exit the file (since data in every single cell of the ranges above isnt mandatory, but can be used). A while back I did this with a word document using form fields and then it would force the user to enter data and the only way to even close the file was to go to task manager and end task. I just want more of a nudge to remind them. Can anyone assist with some VBA?