Is it possible to show a message box in excel?
I am currently writing a SpreadsheetFunctionType.SaveTableView rule and I would like to display a message box to the user with any data validation errors when trying to save.
I have tried :
Throw New XFUserMsgException(si, Nothing, Nothing, "My error message")
However, this doesn't seem to work.
As an alternative, you can have a "Results" or "Comments" column in your table view and display that column to have "SUCCESS"/"FAILURE" or any relevant message with color coding. And user training can be provided for correcting errors as per different validation errors.
Hope this helps.