Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. To validate user input, one possible location for the code is the SheetChange() event procedure of the Workbook object
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    MsgBox (Sh.Name & " "& Target.Address)
End Sub