Shamil Salakhetdinov
shamil at users.mns.ru
Sat Feb 9 04:26:38 CST 2008
Hello John, Excel.Worksheet object has several events related to Excel.Range: Event Change(Target As Range) Event SelectionChange(Target As Range) Event BeforeDoubleClick(Target As Range, Cancel As Boolean) Event BeforeRightClick(Target As Range, Cancel As Boolean) You can try to explore and use these events... Excel.Workbook object has a couple of useful events to implement validation on whole worksheet/workbook level: Event BeforeSave(SaveAsUI As Boolean, Cancel As Boolean) Event BeforeClose(Cancel As Boolean) -- Shamil -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of John Skolits Sent: Saturday, February 09, 2008 12:36 AM To: dba-VB at databaseadvisors.com Subject: [dba-VB] VBA Excel Validation This is more of an excel question but maybe someone can help. Is there a way to do cell validation in Excel. Something like an OnExit event where I can check a value after it's entered? John Skolits _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com