VBA - Drop Down Changes Name to Code but Debug when invalid name is entered

Good Morning/Night all,

I hope you folks are all well.

I was wondering if anyone could please help me. I currently have the following code on my sheet:

Please Login or Register  to view this content.

It basically looks at the selected drop down list name in column 24 (X) and then changes it to a code (by going to another worksheet, matching and returning the code).

But the problem is when an invalid name is entered (one that cannot be matched) then the sheets goes into an error mode i.e that annoying end debug msg box.

Is there anyway to change the code so that the cell can accepts names that it can't match up with, so it doesn't go into error mode?

Thank you in advance for you help guys, much appreciated .

Please Login or Register  to view this content.

Thank you AlphaFrog, you're a legend!!! Works perfectly

I have another related issue that has come about from this if you could please help me on (or anyone else)...

So I also have the following code:

Please Login or Register  to view this content.

it basically automatically says "please select name" on the dependant drop down list cell whenever the primary drop down list is changed, in order to prevent the old selection staying there. This works perfectly fine when a drop down selection is selected but when text is entered manually then nothing happens.

Is there a solution to this?

Many thanks for your help!

Welcome to the forum.

Please take a few minutes to read the forum rules, and then edit your posts to add CODE tags.

Thanks.

After you edit the above posts and add CODE tags, show the code for the entire procedure. Context matters.

Originally Posted by f41yaz

Thank you AlphaFrog, you're a legend!!! Works perfectly

I have another related issue that has come about from this if you could please help me on (or anyone else)...

So I also have the following code:

Please Login or Register  to view this content.

it basically automatically says "please select name" on the dependant drop down list cell whenever the primary drop down list is changed, in order to prevent the old selection staying there. This works perfectly fine when a drop down selection is selected but when text is entered manually then nothing happens.

Is there a solution to this?

Many thanks for your help!

It should work when you enter text manually. You would have to hit enter or select another cell after you enter the text.

You have three versions of the code that don't match. The code in post #6 has If Target.Column = 25 Then which is not in the same column as X25. That code should have worked. Then you changed it to If Target.Column = 24 Then which does conflict with the X25 column. Then your example workbook is completely different. This doesn't make it easy to help you.

Please Login or Register  to view this content.

Originally Posted by AlphaFrog

You have three versions of the code that don't match. The code in post #6 has If Target.Column = 25 Then which is not in the same column as X25. That code should have worked. Then you changed it to If Target.Column = 24 Then which does conflict with the X25 column. Then your example workbook is completely different. This doesn't make it easy to help you.

Please Login or Register  to view this content.

Apologies for that! I thought it would be easier making a sample file but that clearly was the wrong thing to do. Sorry for wasting your time and I appreciate all your help.

Here is the full code:

Please Login or Register  to view this content.

Thanks

Please Login or Register  to view this content.

Please Login or Register  to view this content.