Skip to main content
M
MarkBird
Veteran
June 13, 2023

Display message box in Excel

  • June 13, 2023
  • 3 replies
  • 0 views

Hi

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.

 

Regards,

Mark

3 replies

C
ckattookaran
Newcomer
June 13, 2023

Nope, there is none. I'm not sure if I logged an enhancement request for this. Please log one or ask to get added to that one.

    C
    ckattookaran
    Newcomer
    June 13, 2023

    The exception will log only to the log file. Admins can check it. But not users. The main pain point is, if something fails, it will behave as if everything was good.

      N
      NidhiMangtani
      Veteran
      June 15, 2023

      Hi,

       

      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.

        C
        ckattookaran
        Newcomer
        June 15, 2023

        You can do anything in OneStream. That will work if you return a tableview for every try-catch block.

        Terms & ConditionsAccessibility statement