Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009

    Unanswered: Data Validation Problem

    hello all,

    i have problem with excel data validation.
    when user type on validated cell it work successfully, but when user copy n paste from another cell, the data validation not working.

    for example:
    i have formatted cell A1 as number n set on data validation that
    valid number is between 1 and 10.
    when user type on cell A1, it work successfully, but if user copy value 'test' from another cell n paste it on cell A1, the data validation not working n cell
    A1 which i have formatted as number before changed become text.

    please help me to solve this problem.


  2. #2
    Join Date
    Dec 2003
    Ottawa, Canada

    When the user pastes a value he also pastes the format of the source cell so your data validation is erased.

    You will need to use an input box or a form.
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick

Posting Permissions

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