Open your script editor tools script editor.

Google sheet vba 教学. 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. When you run it it will convert all the formulas in every sheet of your google sheet into values. I found an excel vba code that does the trick below.

Since every recorded macro is defined entirely within apps script you can edit them directly within the apps script editor. You can even write macros from scratch in apps script or take functions you ve already. Private sub worksheet change byval target as range if target row 1 then cells target row b date end sub. Google sheets also automatically updates the script project manifest recording the name and keyboard shortcut assigned to the macro.

Copy and paste the following code onto a new line.