Call <procedure name>
'example Call loadSheet Sub loadSheet() 'code here End Sub
Advertisements
Call <procedure name>
'example Call loadSheet Sub loadSheet() 'code here End Sub
This command is covered in this linked article, set TimeValue to (“00:00:01”)
'place code in a sheet under Microsoft Excel Objects Private Sub Worksheet_Change(ByVal Target As Range) If target.Row = Range("<range of cell>").Row And target.Column = Range("<range of cells>").Column Then <code to be run here> End If End Sub
'example Private Sub Worksheet_Change(ByVal Target As Range) If target.Row = Range("A1").Row And target.Column = Range("A1").Column Then MsgBox("The value of A1 has changed") End If End Sub