Display MsgBox prior to MS error message?

[EssKayKay]

I’m not sure this is possible and not sure I can explain but I’ll try.
I have dropdown lists (K9, K11, K13) of dates that comes from a formula in Range (P33:P500) as follows,

=IF(B34="","",IF(isformula(I34),IF(I34=0,C34," ----- ")," ----- "))

If a date is entered into K9, then that date is no longer available for entry into cells K11 or K13. If a previously entered date is attempted the following error message appears.

I would like a message box to be displayed prior to the above MS error so as to explain why the error is happening.

Thanks,
Steve K.

 

[Anthony47]

The Data validation process allows you to specify an "input message" (a sort of "Tip" that will be displayed when you select the cell) and an "Error message", to be displayed instead of the standard error message (the one that is in your error popup). So look for these Tabs when you set up the data validation, and use them to give proper suggestions to the user

 

[EssKayKay]

The Data validation process allows you to specify an "input message" (a sort of "Tip" that will be displayed when you select the cell) and an "Error message", to be displayed instead of the standard error message (the one that is in your error popup). So look for these Tabs when you set up the data validation, and use them to give proper suggestions to the user

Thanks Anthony that's closer to what I was hoping for. I will place an explanation in the message field that hopefully lets the user know what to do. However, I'm just wondering if there is some way to limit the button options (Yes, No, Cancel, Help) to only one option, say Cancel. If the user inadvertently selects YES, it posts the erroneous value to the cell even though it is not an accepted value.

Thanks again for you time and consideration,
Steve K.

 

[Anthony47]

In the "Error message" tab you can specify the style as a Stopping error, a Warning or an Information; if you select "Stop", the only options available are Retry or Cancel

 

[EssKayKay]

In the "Error message" tab you can specify the style as a Stopping error, a Warning or an Information; if you select "Stop", the only options available are Retry orI should have looked closer - sorry. I still wish but this is better

Got it. I should have looked closer - sorry. I still wish there was only one option but this is much better.
Again, my thanks Anthony - much appreciated.

 

[Anthony47]

Thank you for the feedback

Please note that if you use Office 365 or 2021, it would be quite easy to create a validation list where used values are removed from the validation list.