Validating a Data Entry ...
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Validating a Data Entry ...

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi,

    Say, Cell A3, has Code with a drop down list box. I'm picking the 1st item "cd01". The Code Name is displayed in B3. C3 has division, which is again a drop down list box. I'm picking "APD".

    Next entry by mistake if I happen to select cd01 and APD again, I must display an error message.

    Hope you must have understood my problem.


    I'm getting problem with your edit option. It's not allowing me to edit, so I'm re-entering this question again.

    Regards.

    Rams



  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I think, not sure, that you could use Data Validation for this, with a formula, something like

    =COUNTIF(A$1:A1,A1)=1

    For the "Edit" part... I believe it only allows you to edit it for the next 30 minutes after you have posted.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Board Regular sen_edp's Avatar
    Join Date
    Mar 2002
    Location
    Hellas
    Posts
    555
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello Rams
    go to the following link

    http://support.microsoft.com/support.../Q213/1/85.ASP

    Andreas

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    I don't need the count of it. I want to avoid the redundancy of records being entered. It's just a way of entering unique records.

    How will I display the error message for this ?


    Regards.

    Rams.



  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Dear Sen_edp,

    Thank you very much for the link that you provided to me. I'm currently working on it. If I'm successful in it, I'll inform you.

    Regards.

    Rams.



User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com