Hi,
I am trying to create two Data Validation lists (one dependent on the other). When i change the value in the first drop down i would like the other drop down to show the 1st items in the list. Any ideas?
Thank you...
Hi,
I am trying to create two Data Validation lists (one dependent on the other). When i change the value in the first drop down i would like the other drop down to show the 1st items in the list. Any ideas?
Thank you...
Hi
This is possible on a userform but not on a sheet.
Hi, thanks for the reply. I think i have found an acceptable solution. I have said, that i want to see the word <select> instead of 1st item in the dependent list. With this option I removed, at least, the previous selection from the drop down list.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$4" Then Range("D5").Value = "<select>"
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks