Sets or returns the text contained in a block of script. Read/write String.
Remarks
The Microsoft Office host application doesn’t check the syntax of the script. The ScriptText property is the default property for the Script object.
Example
This example sets the text of the first script in worksheet one in the active workbook.
ActiveWorkbook.Worksheets(1).Scripts(1).ScriptText = _
"MsgBox ""New ScriptText"""