Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004

    Unanswered: Excel Data Validation via VBA

    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???

  2. #2
    Join Date
    Mar 2004
    In the tools menu goto Macros

    In the macros Menu goto Visual Basic Editor

    Double-click the worksheet that you want to make the caluculations in and then select the Calculate Event. Write your code there.

    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts