VBA- Selecting multiple items separated by comma

Hi, I wanted to make a box list with multiple items showing in the same cell but separated by comma. Please advise how to do the following:

1) Revise the code in the attached worksheet so that it will link to the selection located in Tab Sheet2 Column C.
2) Selection is on the same cell separated by comma.
3) No error message or accept input when the data is not in the box list.

Please see attached file.

This is the code which I have taken from internet and I want it to be incorporated on the above file.

Please Login or Register  to view this content.

Thanks & Regards
Jewel

hi Jewel, i changed just this line. basically from the original code where it was 3 to your desired column 2 (Column B).

Please Login or Register  to view this content.

press ALT + F11 to go into VBA editor. go to View -> Project Explorer. you should see a window on the top right. double-click Sheet1 & paste the codes

go to Sheet2 & press CTRL + F3. click on the Named Range NumberList & click on the range below "Refers to". select C2:C12.

go back to Sheet1 & you then need to select B3:B10. go to Data -> Data Validation -> Allow List -> Source:
=NumbersList

save file as xlsm or xls to be able to contain macros. attaching finished eg.

ps: remember to put code tags