Results 1 to 2 of 2

Thread: Data validator

  1. #1
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    eastern Connecticut, Connecticut, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data validator

    If you already have the logic and code to do the validation, you could put this in the Worksheet_Change Event. Assign a name to the range of input cells and then preface your code with a statement using the Intersect method to see if the active cell is in your named range. If so, run your code, if not exit.
    HTH,

  2. #2
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data validator

    I've asked this before in the previous edition of this help group so I'll hope for luck and try try again. Maybe the new year will bring me some resolution in this issue.
    OK, I know how the code will go. It's a simple select case statement [img]/w3timages/icons/thinks.gif[/img]

    I want to verify the users data entry (a simple 3 digit value), in a select case statement. True allows the user to go next and False returns an error message. That part is easy. How do I go about placing this (module) in a range of 25-35 cells of one column? This will only check the contents of the current cell and run the script. No other references are necessary...
    <font color=red>Any takers?</font color=red> WOW!! OK I missed something. There is a reference point and that is from a cell in the same row 2 columns back. This will be either a value, or a blank. God, I hope nulls aren't applicable here.

Posting Permissions

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