Results 1 to 2 of 2

Thread: how to display name in data validation list and save id to database

  1. #1

    how to display name in data validation list and save id to database



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello
    Every one
    We are using data validation list to display name of country our data base table structure is something like this below
    Country ID
    Country –name
    Description

    Now we are displaying country name in data validation list .but we want to save Country ID in different table of our database
    We are using excel 2010, macro, vba

    Can you please provide some reference or code so that I can proceed forward
    Thanks
    Manish

  2. #2
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    183
    Articles
    0
    Excel Version
    2010
    Hi, and welcome to the forum.

    Please read this: http://www.excelguru.ca/content.php?184

    and then update your post to add links to any and all cross-posts in other forums.

    Thanks.
    Circumference of a circle = 2πr²



    ²the circle's radius

Posting Permissions

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