5

In the Excel WebApp (Office 365) it is possible to place Office Scripts via the "Automate" tab, which is using the JavaScript-syntax and which could automate excel like a VBA-macro, but for the excel WebApp (Screenshot).

How is it possible to create an event-listener for a specific cell like cell: A1.
(A scenario would be: If the content/value of cell: A1 is changed then write something in cell: B1)

Screenshot of the excel webapp with office-scripts-code-editor opened

Peter
  • 323
  • 4
  • 15
  • In VBA you add your code in the worksheet.change event, then check if the range changed is the range you want and do the corresponding code you need. Check if the web version have a default event for you to alter and add code. In case of a table you may want to know if the range changed intersect with the desired column of the table. – MVAmorim Oct 30 '20 at 12:37

1 Answers1

2

The Office Scripts doesn't support events yet. You can provide feature feedback at this link:

https://excel.uservoice.com/forums/274580-excel-for-the-web?category_id=143439

Sudhi Ramamurthy
  • 2,358
  • 1
  • 10
  • 14