Combo box - Show dropdown arrow when cell is selected

Hello gundesvan,

Hard to tell without seeing a sample Workbook.

What I do see though is that at the end of your Code you have:

Please Login or Register  to view this content.

While it should actually read:

Please Login or Register  to view this content.

Regards.

Hello gundesvan,

I notice that you have added the changes to your Code as suggested, and I cannot identify what possible problem you could still have. Everything seems to be working fine now, or am I missing something else which you might not have mentioned?

Regards.

@Winon: I was hoping you could clarify the issue in your Post #2. I often wonder about this. Could you please explain why it is necessary to include the

Please Login or Register  to view this content.

directly under

Please Login or Register  to view this content.

even though they already exist below that.
If you left those two lines out, would they not run in any event after the code hit the errHandler line, meaning that if included, they would run twice?

@Mumps,

Thank you for your interest.

If no Error occurs when the Code runs,

Please Login or Register  to view this content.

remains disabled, and the screen will not update as it should.

It touches on Code "Stacking".

Kind Regards.

@Winon: Thank you very much. I was under the impression that if no error occurred, the code would continue to run through the errHandler. I see that this is not the case.

@Mumps,

Thank you for the feedback.

You are welcome, glad I could clarify a bit.

Kind Regards.