How to amend coding for Data Validation refer to a Named Range?

Dear Admin,

I am doing a combo box so that my data validation cell have so called Auto complete function. However, I don't not know how to amend a small part of coding to suit my needs. Please refer to below:

Please Login or Register  to view this content.

Please advice me ! Thanks

Hello montroseite,

Your information is incomplete. Without seeing the Validation formula, I can only guess why your are removing the last character. The code sample you posted is a fragment. You should post the full Sub or Function to provide a complete understanding of what you are doing.

Posting your workbook will answer many questions that won't have to be asked. This saves time, and provides a way to test the code before the solution is posted.