1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • How to make dependent drop down Lists

    From San@21:1/5 to All on Sat May 23 01:23:12 2020
    Hi, I need to select from drop down lists that need to be interlinked and dependent based on the choice made in the preceding list
    Primary List - Coal, Gas Renewables
    Coal List – Anthracite, Bituminous, Lignite, Peat
    Anthracite List - Hi-grade, Low Grade
    Bituminous List – Low Volatile, Medium Volatile, High Volatile
    Lignite – No sub list
    Peat - No sub list
    Gas List - LPG, CNG, LNG
    ( No other sub lists)
    Renewable List – Solar, wind, Hydro, Tidal
    Example : If I choose Coal , the next Drop Down List will show the Coal List. From the Coal List, If I Select “Bituminous” then the next drop down list will show the sublist “Low Volatile, Medium Volatile, High Volatile. Now if I select “
    High Volatile” – the cell takes in the string “High Volatile”
    Any help on how to make this happen .

    Thanks

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Rob P@21:1/5 to All on Sat May 23 04:19:49 2020
    Hi,
    A great YouTube video from Leila Gharani on doing this https://www.youtube.com/watch?v=7mo4COng7Sg

    Hope this helps

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From GS@21:1/5 to All on Sat May 23 11:26:07 2020

    Hi, I need to select from drop down lists that need to be interlinked and dependent based on the choice made in the preceding list Primary List - Coal, Gas Renewables Coal List – Anthracite, Bituminous, Lignite, Peat
    Anthracite List - Hi-grade, Low Grade
    Bituminous List – Low Volatile, Medium Volatile, High Volatile
    Lignite – No sub list
    Peat - No sub list
    Gas List - LPG, CNG, LNG
    ( No other sub lists)
    Renewable List – Solar, wind, Hydro, Tidal
    Example : If I choose Coal , the next Drop Down List will show the Coal List. From the Coal List, If I Select “Bituminous” then the next drop down
    list will show the sublist “Low Volatile, Medium Volatile, High Volatile. Now if I select “High Volatile” – the cell takes in the string “High
    Volatile” Any help on how to make this happen .

    Thanks

    See here...

    https://www.contextures.com/xlDataVal02.html

    --
    Garry

    Free usenet access at http://www.eternal-september.org
    Classic VB Users Regroup!
    comp.lang.basic.visual.misc
    microsoft.public.vb.general.discussion

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From San@21:1/5 to Rob P on Sun May 24 06:56:00 2020
    On Saturday, May 23, 2020 at 4:49:51 PM UTC+5:30, Rob P wrote:
    Hi,
    A great YouTube video from Leila Gharani on doing this https://www.youtube.com/watch?v=7mo4COng7Sg

    Hope this helps

    Thanks . Will check

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)