Importing selected data type into a single cell as desired

Hello friends

Happy New Year to all

May I ask for your help on the subject in due time?

Dear sintek,

Thank you very much. This method is as my request.

Originally Posted by kvsrinivasamurthy

I have added codes. Pl see.

Please Login or Register  to view this content.

Dear kvsrinivasamurthy,

It must be enclosed in as many cells as the selected criterion.

Thank you.

Except for this method. We use this if we need to select all criteria.

Dear Sintek

it's like it doesn't add single quotes at the very beginning

will each criterion be in single quotes

I missed it while asking a question.
I did not express the quotes at the beginning of the criterion

'IA','HS','NK' example.

Dear kvsrinivasamurthy ,


We will only choose type codes
because we get reports taking into account type codes
such as bills, checks, promissory notes
you can arrange in this direction
The criteria selected from the listbox will be transferred to the cell.

'IA','FA','D' example.

The codes written by Mr. Sintek seem to be working.