Thanks Thanks:  0
Likes Likes:  0
Page 6 of 12 FirstFirst ... 45678 ... LastLast
Results 51 to 60 of 116

Thread: cascading combo boxes...???

  1. #51
    Board Regular
    Join Date
    Oct 2002
    Location
    Mahesh
    Posts
    419
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am referring to the example given by Aladin Akyurek in the beginning of this thread

  2. #52
    New Member
    Join Date
    Nov 2005
    Location
    Florida
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Cascading data validation

    WOW, This is much easier than the nested formulas I have been using!

    :o

    I found this post on my search for the following: I have xl 2000 and when I protect the cells with the list validation anyone with xl 2000 can use the drop down to change the value of the cell, anyone with xl 2003 gets an error that the cell is protected and read only. I have access to xl 2003 on another computer if someone could tell me the fix I need to do to the spreadsheet.
    I have tried to send this out into the world with out protection but alas people alway cut, copy, paste, and lose the validation.

    :huh:

    Thanks

  3. #53
    Board Regular
    Join Date
    Nov 2005
    Location
    US
    Posts
    80
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    that works but what if I need drop down list that stretch 20 rows down? In other words I need multiple drop downs with the same validation. Am I making sense

  4. #54
    Board Regular
    Join Date
    Dec 2004
    Location
    Durham, NC
    Posts
    1,220
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Maybe it's just me, but I have a hard time following 6 pages of thread so I was wondering if anybody has sort of generic file they could post somewhere? One that brings it all together. This topic is fascinating to me!

    DJ

  5. #55
    Board Regular
    Join Date
    Nov 2005
    Location
    Holland
    Posts
    112
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is it possible to put 2 possible dropdown in a sheet.
    ******** ******************** ************************************************************************>
    Microsoft Excel - Map3___Running: 11.0 : OS = Windows XP
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    A
    B
    C
    D
    E
    F
    1
    2
    CodeNameInstitute
    3
    c_1astd
    4
    c_2blog
    5
    c_3crij
    6
    c_4dstd
    7
    8
    9
    Code Name Institute
    10
    c_2 b log
    11
    12
    13
    14
    Blad1

    [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
    For example

    I have the following data C2:E6.
    If i make a dropdown menu in B10 it's possible to fill in D10 and F10, with VLOOKUP (vert.zoeken = VLOOKUP).
    But what if i want choose to select a Code (B10) or a Name (D10).

    So when i make a second dropdown menu in D10 that B en F are filled in.
    Is this possible?
    Win Xp, Office 2007

  6. #56
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,653
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    Quote Originally Posted by kapfrank
    Is it possible to put 2 possible dropdown in a sheet.

    ...

    I have the following data C2:E6.
    If i make a dropdown menu in B10 it's possible to fill in D10 and F10, with VLOOKUP (vert.zoeken = VLOOKUP).
    But what if i want choose to select a Code (B10) or a Name (D10).

    So when i make a second dropdown menu in D10 that B en F are filled in.
    Is this possible?
    Not with formulas...

  7. #57
    Board Regular
    Join Date
    Dec 2004
    Location
    Pennsylvania
    Posts
    983
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default duplicates

    can you have duplicates in the list

    let say Paris in france and paris in USA

  8. #58
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,653
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default Re: duplicates

    can you have duplicates in the list

    let say Paris in france and paris in USA
    Yes.

  9. #59
    Board Regular
    Join Date
    Dec 2004
    Location
    Pennsylvania
    Posts
    983
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default not working

    http://www.ozgrid.com/News/excel-dep....htm#ExcelTips

    When i try the example in the above mentioned site it works

    when i try to recreate it mine wont work

    I have excel 97

  10. #60
    MrExcel MVP erik.van.geit's Avatar
    Join Date
    Feb 2003
    Location
    Belgium 3272 Testelt
    Posts
    17,832
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: not working

    http://www.ozgrid.com/News/excel-dep....htm#ExcelTips

    When i try the example in the above mentioned site it works

    when i try to recreate it mine wont work

    I have excel 97
    to my sense you would better start a thread for your specific problem
    tell what you did and what didn't work ...

    kind regards,
    Erik
    I love Jesus

    email Erik

    founder of DRAFT

    my free Addins
    Table-It download & info
    Formula Translator 04

Some videos you may like

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
  •