Multiple Dropdown Searchable List (VBA)

[rodineyson]

Hello All,

I saw an old post regarding an automated search cell (https://chandoo.org/forum/threads/multiple-dropdown-lists-with-same-data.25687/). I tried implementing the code but I just can´t get it to work. See my code below and my spreadsheet attached.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 And (Target.Row > 5 And Target.Row < 27) Then
Sheet1.[G1] = ActiveCell.Row
End If
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 2 And (Target.Row > 5 And Target.Row < 27) Then
Sheet1.[G1] = ActiveCell.Row
End If
End Sub

Can you help me out?

Thank you!!!

 

[Chihiro]

Works fine on my end when tested. What exactly isn't working?


Also, you can checkout alternative setup without VBA in thread below.
https://chandoo.org/forum/threads/searchable-drop-down-without-vba.38037/

 

[rodineyson]

Thanks for the reply!

That's weird. On my spreadsheet, cell G1 (which I assigned the macro to), does not change values based on the active cell of the dropdown. Did you check the consecutive cells on column B (Cell B2, 3, 4, etc...)?

Thanks again for the help!!

 

[Chihiro]

Yep. Works perfectly fine.

 

[rodineyson]

Alright. Thanks! Maybe it's a setting on my Excel config regarding the macro. I'll check it out!

Thanks for the help anyway!