Currently in the process of migrating all my VBA scripts to Excel Online automation. Does anyone know how to convert MsgBox from VBA to Excel Online automation?
Example: MsgBox "Some Text"
I am linking my code to buttons for users to click on. I want to make sure my code is user-friendly, but at the moment, the only way a user will see a generated message is if they select "View Logs" to read messages from a console.log("Some Text").
I just want to ensure that important messages are being noticed so I don't end up with a flood of questions about why something didn't work or what went wrong. Often times, the code itself runs correctly but users need to address the message and run it again. Messages could be as simple as "Date missing from input box" or "Data has not been updated. Please update and try again."
Appreciate any help in advance!