Results 1 to 2 of 2

Making 2 Dependable drop downs

Threaded View

  1. #1
    Registered User
    Join Date
    12-16-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    1

    Making 2 Dependable drop downs

    Sub Test()
    'drop down list
    Dim language As Variant
    Dim team As Variant
    
    language = [{"KA", "KT", "PJ", "TU"}] ' assign value
    'put in K2 array language
    With Range("K2").Validation
    .Delete
    .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
    Operator:=xlBetween, Formula1:=Join(language, ",")
    End With
    
    team = [{"Team 1", "Team 2", "Team 3"}] ' assign value
    'put in J2 array team
    With Range("J2").Validation
    .Delete
    .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
    Operator:=xlBetween, Formula1:=Join(team, ",")
    End With
    End Sub

    When I click on Team 1 it should KA, KT and when I click on Team 2 it should show PJ and when I click on Team TU only. Currently they are just 2 drop downs want to make them dependent drop downs.

    If team = "Team1" Then
    language= "KA,KT"
    ElseIf team = "Team2" Then
    language= "GU"
    ElseIf team = "Team3" Then
    language= "KA"
    Else
    End If
    The data for both the drop down should not come from excel sheet. I want to hard core the code with the drop down values and make them dependable drop downs.

    Any help is much appreciated.
    Last edited by AliGW; 12-16-2019 at 02:45 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to create dependable / cascading drop down list in Outlook?
    By naran_sed in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 08-25-2019, 01:05 PM
  2. Dependable drop down lists- multiple rows.
    By crowmatt in forum Excel General
    Replies: 2
    Last Post: 03-31-2017, 09:10 AM
  3. Initial default drop downs and dependent default drop downs
    By hudsone777 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-07-2016, 07:05 PM
  4. [SOLVED] Drop Downs conditional on drop downs
    By BillTD in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-06-2015, 09:40 AM
  5. Auto-update initial drop-down selection based on previous drop-downs
    By thornomad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2010, 09:55 AM
  6. Use Drop Downs to Populate Other Drop Downs
    By fbombs in forum Excel General
    Replies: 2
    Last Post: 09-23-2009, 03:17 PM
  7. making drop downs "volatile"
    By Wazooli in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2005, 09:06 PM

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