If Not Intersect(Target, MyRange) Is Nothing Then In this example, we compare the Target with the given cell range A1:A10 using Intersect method: Private Sub Worksheet_Change(ByVal Target As Range) The Worksheet_Chnage procedure receives the Target as Range object which represents the changed cell(s). Monitor changes made to specific cell or range Try making some changing in cells, every time you make changes, a message box displays the address of the cell that changed. The following example displays a message box that shows the address of the Target range: Private Sub Worksheet_Change(ByVal Target As Range) The Worksheet_Change procedure accepts Target (the Range object) as the parameter which represents the cell that was changed.
Excel uses the Worksheet_Change event-handler procedure to trap the Change event. The Change event triggers whenever any cell in the worksheet is changed. You can quickly access that code window by right-clicking the worksheet’s tab and selecting the View Code: Put them somewhere else, and they won’t work. The worksheet event-handler procedures must be in the code module for that worksheet.
0 kommentar(er)
