Is there a way programatically using VBA to respond to an Excel 5 dialog
box that pops up? Hope this makes sense. Any code would be certainly
Is there a way to validate edit-box entries in a custom
dialog box on a box-by-box basis -- that is, when users
tab out of each box -- rather than when the users hit "OK"
to exit the dialog itself?
My dialog now launches a validation routine when users
hit "OK" to continue -- if the input's clean, it moves
along; if the input requires correction it reopens the
dialog and prompts for corrected entries.
I would much prefer to trap and notify as soon as users
hit TAB to move out of each edit box. The validation
is tricky -- I can't use the built in validation features
for this, and I'm not sure that those trigger on TAB
either. . . .