[Jean-Guy Marcil[_2_]]

"Kim K" wrote:

Thank you Jean-guy, would this work similarily with a simple pop up box at my
last textfield of drop dpwn to say something like, please be sure infomraitno
is complete before saving, not a blank field macro as some fields will remain
blank due to student demographic info, but just a reminder to check work
before saving.

Of course, you can use this on all or just some of the dropdowns. Just
modify the Case Select to have it react to the values in the dropdown you
want. For now, because it is easier, just use as many different macros (each
with a unique name) as you have dropdowns. You can remove the Select case if
you want it to display a message regardless of the values in the dropdown.

As for some sort of message in the last drpdown, the only problem is that
you cannot guarantee that all users will click into, much less click out of,
the last dropdown field. I, however, can guarantee that some users will not
use/click into that last dropdown! ;-)