VBA to hide rows does not work with DropDown

Goal: Hide rows based on value in Drop Down Box

Problem: The code works fine if i manually change the $D$10. If I make changes to the Drop Down Box the cell link updates, but the rows are not hidden.
Can anybody help?

Code:

Please Login or Register  to view this content.

Thanks for the recommendation - but it doesn't work either. Same problem.

Hi Steve1104,

Check the attached file & the macro's in it.
Hope this works for you.

Regards,
xlman

Thanks for the help. In xlmans XLS-File I saw, that his drop down looked different. I was using a "Combo Box (Form Control)" - and obviously was not able to use it correctly. Now I switched to a Drop-Down (Data--> Data validation) and it works fine.
The Active-X combo also didn't work - even though I think I put the code on the right place - but I assume the problem sits in front of the screen and there would be an easy solution to that.

Good that your problem is solved.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

Quick method:
Select Thread Tools-> Mark thread as Solved.

You may also thank all those helped you, by clicking on the little star at the bottom left.