Error handling for Combobox application vlookup...

[sintek]

Hello World...

I have below code for Combobox Change...It works but prior gives a error message invalid property value at red part of code...???Any ideas

Please Login or Register  to view this content.

[davesexcel]

It would be nice to be able to test the code.

I was just doing a simple mockup code to see what was going on.

Please Login or Register  to view this content.

When I use numbers in column O, I would get an error, but when I use text in column O, it works just fine,
-
-
Numbers
Using NumbersVlookup.JPG
-
-
Text
-
Using TextVlookup.JPG
-
-
You may want to consider using "Find" instead. Then if your item is not found you can do something.

[sintek]

Hi davesexcel

You pointed me in the right direction...I set the comboBox property "Match required" to false and made use of following:Works like a charm
Thanks a mill.

Please Login or Register  to view this content.