cascading combo boxes...??? - Page 7
Thanks Thanks:  0
Likes Likes:  0
Page 7 of 12 FirstFirst ... 56789 ... LastLast
Results 61 to 70 of 116

Thread: cascading combo boxes...???

  1. #61
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,053
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi, guyz & galz.

    I'm VBA challenged (a complete idiot, in fact). Can anyone come up with a Worksheet_SelectionChange or Worksheet_Change code to blank out cell D4 (my dependent validation cell) whenever cell B4 (my primary validation cell) is edited (either the contents deleted or a new choice made).

    Thanx.
    Barry-

    Photo Restoration/Enhancement

    http://www.smiledogproductions.com
    click below for detour


  2. #62
    New Member
    Join Date
    Mar 2006
    Posts
    30
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    I've setup a worksheet that has a TEAM listing (Teams 1 to 10), which I have used to populate ComboBox1 on a Userform. I have named this as a range called TEAMS.

    On a seperate sheet, I have another list which has players registered to each team. Some teams have 10 players, some have 20 players, etc.

    This PLAYER listing is a 2 column list, the first column being the team and the second being the Player Name. I have set the whole of this listing to the name PLAYERS.

    I want my second Combobox on the Userform to show only the players that are registered againat the team selected in ComboBox1. i.e only show the PLAYER list when the first column is the same as the one in Combobox1.

    I've spent ages trying to get this to work. I'm only a VBA baby so this may be a very simple bit of code.

    Hope that this makes sense!!

    Can anyone help?

    Cheers

    Simon

  3. #63
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling
    Posts
    73,121
    Post Thanks / Like
    Mentioned
    17 Post(s)
    Tagged
    0 Thread(s)

    Default

    Simon

    Could you start a new thread for this?
    If posting code please use code tags.

  4. #64
    Board Regular
    Join Date
    Mar 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default I Just Can't Get This to Work

    I searched the forums for what I am trying to do, and this example looks perfect, but something is missing - I can't get it to work.

    What I have is:

    Column 1 =
    Expenditure Type
    Asset Category
    Column 2 =
    Admin-All Staff Functions
    Admin-Bus Licenses
    Admin-Charitable Donations
    Admin-Comm Cellular
    Column 3=
    Building-Rate 4
    Building-Rate 5
    Building-Rate 8
    Building-Rate 10

    When "Expenditure Type" is selected in the pseudo combo box I want the 2nd pseudo combo box to contain the data listed in column 2

    When "Asset Category is selected, I want the list to contain the data in column 3

    How is this done step-by-step?
    Thanks.

  5. #65
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,786
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default Re: I Just Can't Get This to Work

    I searched the forums for what I am trying to do, and this example looks perfect, but something is missing - I can't get it to work.

    What I have is:

    Column 1 =
    Expenditure Type
    Asset Category
    Column 2 =
    Admin-All Staff Functions
    Admin-Bus Licenses
    Admin-Charitable Donations
    Admin-Comm Cellular
    Column 3=
    Building-Rate 4
    Building-Rate 5
    Building-Rate 8
    Building-Rate 10

    When "Expenditure Type" is selected in the pseudo combo box I want the 2nd pseudo combo box to contain the data listed in column 2

    When "Asset Category is selected, I want the list to contain the data in column 3

    How is this done step-by-step?
    Thanks.
    Here is how it is done...

    ******** ******************** ************************************************************************>
    Microsoft Excel - Book3___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
    1
    MainListSubList-1SubList-2
    2
    Expenditure Type Admin-All Staff Functions Building-Rate 4
    3
    Asset CategoryAdmin-Bus Licenses Building-Rate 5
    4
    Admin-Charitable DonationsBuilding-Rate 8
    5
    Admin-Comm CellularBuilding-Rate 10
    6
    7
    Sheet1

    [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.


    Select A2:A3 and name it (via the Name Box) MainList

    Select B2:B5 and name it (via the Name Box) ExpenditureType. Note the absence of space!

    Select C2:C5 and name it (via the Name Box) AssetCategory. Note the absence of space!

    Try the following...

    Select F2.
    Activate Data|Validate.
    Choose List for Allow.
    Enter the following in the Source box:

    =MainList

    Click OK.

    Select G2.
    Activate Data|Validate.
    Choose List for Allow.
    Enter the following in the Source box:

    =INDIRECT(SUBSTITUTE(F2," ",""))

    Click OK.

  6. #66
    MrExcel MVP tusharm's Avatar
    Join Date
    May 2002
    Posts
    11,007
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default

    For a solution to dependent lists (or cascading queries) that uses data in relational tables see
    Cascading queries
    http://www.tushar-mehta.com/excel/ne...wns/index.html

  7. #67
    New Member
    Join Date
    Dec 2006
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    That was alot of help! But is there a way to have some of the information in the first drop-down point to the same information. For example: if the information in the first drop-down menu was: A Segment, B Segment, and Overlay and I want anything with the word Segment in it to point to the same menu but Overlay point to a different one.

    I tried to do a Name with *Segment but that obviously didn't work.

  8. #68
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,786
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    That was alot of help! But is there a way to have some of the information in the first drop-down point to the same information. For example: if the information in the first drop-down menu was: A Segment, B Segment, and Overlay and I want anything with the word Segment in it to point to the same menu but Overlay point to a different one.

    I tried to do a Name with *Segment but that obviously didn't work.
    See:

    http://www.mrexcel.com/board2/viewtopic.php?t=247568

  9. #69
    Board Regular RichardMGreen's Avatar
    Join Date
    Feb 2006
    Location
    Somewhere beyond the Twilight Zone
    Posts
    2,162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: cascading combo boxes...???

    Does anyone know if INDIRECT can be used with list boxes rather than comboboxes?
    RichardMGreen

    Flagellation, necrophilia and bestiality - Am I flogging a dead horse?

    Office 2003/2007 (Work) and Office 2007 (Home)

  10. #70
    New Member
    Join Date
    Dec 2007
    Location
    Argentina
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: cascading combo boxes...???

      
    Dear Eric
    I have the same problem as you quote here. Were you able to solve it?

    Wereman

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