Scroll to the specific cell from dropdown menu.

[besis]

Hi,

I have on B2 a dropdown menu that contains following texts: Television(cell A5), Stereo(cell A8) and Mobile(cell A11)

How to create a VBA code that: when I select from dropdown menu for example Stereo, it will scroll to cell A8.



Thanks in advance.
B.

[bakerman2]

To start with.

Please Login or Register  to view this content.

[besis]

Hi,

Thank you for this solution. This is finding the correct cell after matching.
Do you know how can I modify the code so it also scroll to the right cell after matching (I mean ActiveWindow.ScrollRow = 8 ►would be for Stereo)

Thanks for helping.
B.

[bakerman2]

Please Login or Register  to view this content.

[besis]

Hi,

It works well. Thanks a lot for this. I am also trying to figure it out how to unhide the below rows of the matched result.
That say that it scrolls to Mobile and if under Mobile rows 12 and 13 are hidden. How can I unhide those rows automatically all the way to the row that contains for example END3 value?
I need this also for other products Stereo and so on (for Stereo would be the END2 value). The reason I need this is because there are many products and the list is this way mutch shorter if I hide specific rows.

Sorry for asking continually under this same thread. Just that when I run the VBA code i get stuck to continue to get the hole problem solved :-(

Thanks for any help I can get.
B.