+ Reply to Thread
Results 1 to 5 of 5

A drop down box that is different between the "text" chosen and the "value" appears

  1. #1
    Registered User
    Join Date
    09-12-2012
    Location
    Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    7

    A drop down box that is different between the "text" chosen and the "value" appears

    Hi all,

    Its nice to finally join this forum.

    I have to questions:

    1. How to make a drop down box that looks like cell D1 in the attached file?

    2. How to make a similar drop down box, but with a changed value appears once clicked? The file attached may illustrate better.


    Would really appreciate if any of you could help me with this.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: A drop down box that is different between the "text" chosen and the "value" appears

    Not sure what you mean? Do you mean get the value in column b on sheet2, Id so try this formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Registered User
    Join Date
    09-12-2012
    Location
    Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: A drop down box that is different between the "text" chosen and the "value" appears

    Yes, that is exactly what i meant. Mind the messy language.

    Noted, thanks for your reply. But how to build the "drop down box" itself? I copied the drop down box in the file attached from a blog.

    Thanks.

  4. #4
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: A drop down box that is different between the "text" chosen and the "value" appears

    O... Ok there are plenty of examples if you google "Excel Data Validation List from another Worksheet"

    or this link may work

    http://www.exceldigest.com/myblog/20...rop-down-list/

  5. #5
    Registered User
    Join Date
    09-12-2012
    Location
    Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: A drop down box that is different between the "text" chosen and the "value" appears

    Hi Mike,

    It works.

    Thanks a lot. I really appreciate it.

    Fawwaz

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1