<div>
Thanks for your suggestions. &nbsp;This is the direction I will go with this situation.
</div>


<div>
You're very welcome.<br />
<br />
If you hit any barriers to progress, please come back to this thread.
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I am not sure this is even possible, but I thought I would run it by you in case there is a way. &nbsp;When there is an error generated in Excel's data validation process, is there a way to generate form to popup instead of a message box.<br />
<br />
If the user wants to add an entry to the controlled list that isn't there, then I would like to have a userform popup with instructions on how to add the new entry to the controlled list.<br />
<br />
<br />
Thanks in advance<br />
<br />
JJ
</div>
</div>


Hi Experts,

I am not sure this is even possible, but I thought I would run it by you in case there is a way.  When there is an error generated in Excel's data validation process, is there a way to generate form to popup instead of a message box.

If the user wants to add an entry to the controlled list that isn't there, then I would like to have a userform popup with instructions on how to add the new entry to the controlled list.


Thanks in advance

JJ

Thanks for your suggestions.  This is the direction I will go with this situation.

You&#39;re very welcome.

If you hit any barriers to progress, please come back to this thread.

Excel Data Validation Error Message Alternatives

Hi Experts,

I am not sure this is even possible, but I thought I would run it by you in case there is a way.  When there is an error generated in Excel&#39;s data validation process, is there a way to generate form to popup instead of a message box.

If the user wants to add an entry to the controlled list that isn&#39;t there, then I would like to have a userform popup with instructions on how to add the new entry to the controlled list.


Thanks in advance

JJ

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.