• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

multiple dropdown lists with same data

Hi:

Is this what you are looking for.

Thanks

Hi:

This worked well for me but I can only apply it to one column with multiple rows in my worksheet.

Do you have a solution like this if there are multiple columns per row that need to have a searchable drop down list?
 
@Biigoz, I have used the following code to get the active cell row.
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 And (Target.Row > 10 And Target.Row < 33) Then
Sheet1.[K1] = ActiveCell.Row
End If
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 3 And (Target.Row > 10 And Target.Row < 33) Then
Sheet1.[K1] = ActiveCell.Row
End If
End Sub
Thanks


Try to put =CELL("row") in K1 of Sheet1 instead og using VBA. It works for me.
 
Back
Top