+ Reply to Thread
Results 1 to 3 of 3

Multiple Rows and Columns in Dependent Dropdown Lists

  1. #1
    Registered User
    Join Date
    06-26-2013
    Location
    Canberra, Australia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Unhappy Multiple Rows and Columns in Dependent Dropdown Lists

    Hi All,

    I am having major dramas with this spreadsheet.

    I am trying to create multiple dependent drop down lists. I need 4 rows across and 20 down, Basically what I need is a combination of this: http://www.get-digital-help.com/2010...lues-in-excel/

    and this: http://www.get-digital-help.com/2010...multiple-rows/

    Does anyone know a fix for this? I would really appreciate some help.

  2. #2
    Registered User
    Join Date
    06-26-2013
    Location
    Canberra, Australia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Unhappy Re: Multiple Rows and Columns in Dependent Dropdown Lists

    While I'm hasseling you fine people...

    I have this code below in VBA:

    Private Sub Worksheet_Change(ByVal Target As Range)

    If Worksheets("Sample Validation").Range("O3,O4,O5,O6,O7,O8,O9,o10,o11,o12,o13,o14,o15,o16,o17,o18,o19,o20").Value = "Yes" Then _
    MsgBox ("Message.")

    If Worksheets("Sample Validation").Range("P3,P4,P5,P6,P7,P8,P9,P10,P11,P12,p13,p14,p15,p16,p17,p18,p19,p20").Value <> "Corporate & Business Management" Then _
    MsgBox ("Message.")


    End Sub

    But I need those two if statements to function independently. At the moment, if O3 is yes, it will show the message for both if statements.

  3. #3
    Registered User
    Join Date
    06-26-2013
    Location
    Canberra, Australia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Multiple Rows and Columns in Dependent Dropdown Lists

    So I found a solution to the second problem I have listed. I've updated to code so that it now looks like this:

    Private Sub Worksheet_Change(ByVal Target As Range)

    If Worksheets("Sample Validation").Range("O3,O4,O5,O6,O7,O8,O9,o10,o11,o12,o13,o14,o15,o16,o17,o18,o19,o20").Value = "Yes" And Worksheets("Sample Validation").Range("P3,P4,P5,P6,P7,P8,P9,P10,P11,P12,p13,p14,p15,p16,p17,p18,p19,p20").Value = "" Then _
    MsgBox ("Message")


    If Worksheets("Sample Validation").Range("P3,P4,P5,P6,P7,P8,P9,P10,P11,P12,p13,p14,p15,p16,p17,p18,p19,p20").Value <> "Comething" And Worksheets("Sample Validation").Range("P3,P4,P5,P6,P7,P8,P9,P10,P11,P12,p13,p14,p15,p16,p17,p18,p19,p20").Value <> "" And Worksheets("Sample Validation").Range("O3,O4,O5,O6,O7,O8,O9,o10,o11,o12,o13,o14,o15,o16,o17,o18,o19,o20").Value = "No" Then _
    MsgBox ("Message")

    End Sub


    Still looking for help with the first issue if anybody has any time!

    Thanks!

+ 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