[excel 365] autocomplete drop down that runs runs additional code based on value

Hello,

So i am trying to make a part list that you can use a drop down with the part number, or the description. that will auto fill the other side with the correct matching thing. I have that part of my code working good. This is that code.

Please Login or Register  to view this content.

Then I wanted to add a autocomplete thing. so if someone starts typing it will help the user find the right part. I found this on another website and thought maybe I could have both sub's in the working, it works on selection change, mine works on value change. Although they have a double click version i haven't tried. Below is the code.

www-contextures-com-xlDataVal14-html (website that i can't link because im new here. but i think it is important for my reference)

Please Login or Register  to view this content.

When I use the auto complete however, my value change code doesn't fire. Is there a better way?

Thanks