Message Box Display via Cell Change

roselyn12 · Mar 20th 2017, 3:18pm

Hello team,

Is there's a way to display a Message Box regardless if its via Macro or Widget and trigger it when a cell value change?

Thanks

Seaben · Mar 20th 2017, 4:39pm

If you link that cell to a cube via palo.data(), you can use the SVS with InitCubeWorker.
Then you just have to figure out how to access the macro engine, I think?

laloune · Mar 21st 2017, 2:42pm

hello,

the sep_error instruction raises a msgbox also in the web interface (from v6 onwards)

roselyn12 · Mar 23rd 2017, 2:50pm

Do you have sample function how sep_error works?
Because in my case I'm splashing data let say in cell A if this data is greater than the value cell B they I should have this msg box saying the value imputed cannot be written as this is greater than the value from cell B.

Seaben · Mar 24th 2017, 9:02am

In that case I woudln't make it too complicated. Don't let the user input directly into a DATA-function, instead use a SETDATAIF-function and a button to splash the value. THen you can implement restriction checks and UI information in various ways.

Message Box Display via Cell Change

Message Box Display via Cell Change

Share

Users Online 1

Similar Threads