How can I get VBA to check data as it is input into an Excel spreadsheet? Assuming all data is okay, nothing should happen, but I need to be able to check for criteria that are too complex for the normal Excel data validation functionality. I have seen it done before, but how do I get started???
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!