Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

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