在Google表格中使用VBA进行自动 [英] Use VBA in Google Sheets to auto

问题描述

我找到了一个excel VBA执行这个技巧的代码（下面）。

  Private Sub Worksheet_Change（ByVal Target As Range）
如果Target .Row> 1 Then Cells（Target.Row，B）= Date 
 End Sub 
  

您知道如何以表格的形式进行这项工作，无论是作为功能还是作为代码？ Google表格不支持 VBA - 代表Visual Basic for Applications（一种从Visual Basic派生的Microsoft语言）。

支持什么表格 Javascript功能与宏一样工作。

请查看了解更多关于Javascript宏的信息。

I am trying to get a google doc to include an auto-fill of that day's date whenever a value in a row is changed.

I found an excel VBA code that does the trick (below). However, it won't work in google sheets.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row > 1 Then Cells(Target.Row, "B") = Date
End Sub

Do you know how to make this work in sheets, either as function or as code?

解决方案

Google Sheets does not support VBA -- which stands for Visual Basic for Applications, a Microsoft language derived from Visual Basic.

What Sheets does support is Javascript functions working just as macros.

Check this out for more information on Javascript macros.

这篇关于在Google表格中使用VBA进行自动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！