ScriptText Property

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"""