Hi Guys.

I have a file containing Macros in a SharePoint, unfortunately i need to start using excel online and the VBA macro is not running, since this is a file to be share by a team of 10 people working simultaneous I need to have the file updated at all times, for that we must use excel online just like google docs example.

I already tried, but the language is completely different and I'm unable put the file online... Is there any way of converting a VBA macro into Office Script in a easier way?

The code is very simple, I just need to copy the text from the cell from the left cell, and add to the last comment in the right cell without deleting the full text that already exists, just to add.

Function:

Left Cell: Written Comment
Triger: Enter
Right cell (Office Script): Add the original left comment to the Right cell containing a Time and Date header in the beginning of the copied comment Text (from the left to the right cell, this function must not delete the other comment, just add)

Example: A1= France ?Enter? B1= (2023-01-24 12:00) France (2023-01-23 11:00) Paris (2023-01-22 14:00) Bordeaux

Tanks in advance!