Dependant drop down list
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Dependant drop down list

  1. #11
    Board Regular
    Join Date
    May 2006
    Location
    New Jersey
    Posts
    420
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Dependant drop down list

    Hi Akuini

    That fixed it!
    Would you be so kind to help me with 1 more fix?

    In Sheet1, column B is the floor# and column C is the persons name. Column D is other information. I would like to clear the row in column C & D when the floor# is removed.

    This would be great.

    Thank you!!!
    Words alone cannot explain how grateful that I am to all the people here
    that take the time to help others and myself!
    Grateful member since 2006.

  2. #12
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    1,750
    Post Thanks / Like
    Mentioned
    26 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Dependant drop down list

    Quote Originally Posted by Russk68 View Post
    Hi Akuini

    In Sheet1, column B is the floor# and column C is the persons name. Column D is other information. I would like to clear the row in column C & D when the floor# is removed.
    OK, add this code to the sheet1 code window:

    Code:
    Private Sub Worksheet_Change(ByVal Target As Range)
    'change both Range("B2:B10") below to suit
    
    If Not Intersect(Target, Range("B2:B10")) Is Nothing Then
        Dim c As Range
        For Each c In Intersect(Target, Range("B2:B10"))
            'clear the row in column C & D when the floor# (col B) is removed.
            If Len(c.Value) = 0 Then c.Offset(, 1) = "": c.Offset(, 2) = ""
        Next
    End If
    End Sub
    Note:
    If you have ~1000 item of floor then I suggest for the data validation of floor (sheet1 col B) you use a searchable combobox instead of data validation, because selecting from ~1000 items is difficult.
    You can find an example of a searchable combobox in this thread:
    https://www.mrexcel.com/forum/excel-...selection.html

  3. #13
    Board Regular
    Join Date
    May 2006
    Location
    New Jersey
    Posts
    420
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Dependant drop down list

    That works great!

    This has greatly improved my productivity.

    Also, commenting the link to this post is brilliant! I will be doing that for now on.

    Thank you very much for your time. It is greatly appreciated!!!

    Russ
    Words alone cannot explain how grateful that I am to all the people here
    that take the time to help others and myself!
    Grateful member since 2006.

  4. #14
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    1,750
    Post Thanks / Like
    Mentioned
    26 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Dependant drop down list

    You're welcome, glad to help, & thanks for the feedback.

Some videos you may like

User Tag List

Tags for this Thread

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
  •