Search notes:

Examples for VBScript MS-Office App Creator: Excel (Worksheet events)

The following example demonstrates how it is possible to create worksheet event procedures with the VBScript MS-Office App Creator.

sheet1.bas

option explicit

private sub worksheet_selectionChange(byVal target as range) ' {

   activeSheet.cells(2, 2).value = "You clicked " & target.address

end sub ' }

Github repository VBS-MS-Office-App-Creator, path: /examples/Excel/worksheet_event/sheet1.bas

create.wsf

option explicit

private sub worksheet_selectionChange(byVal target as range) ' {

   activeSheet.cells(2, 2).value = "You clicked " & target.address

end sub ' }

Github repository VBS-MS-Office-App-Creator, path: /examples/Excel/worksheet_event/sheet1.bas

Result

Index