How do I get a user form to recall list box selections from a worksheet?

[NorthbyNorthwest]

Hi, everyone. Hope someone can help me finish a project I am working on. It is a user form to control data entry. The actual worksheet is hidden by code; so, users can only input, update, and delete records through the user form. Thanks to a lot of internet help including this message board I have been successful in the past. My earlier user forms were a combination of text and combo boxes. The user form I am now working on has text boxes, combo boxes, and 20 multiselect list boxes. The user can add data from the user form to the next empty row in worksheet. My problem is when the user would need to update a record.

I know how to find the row in question and how to return text and combo box values to the user form from the worksheet. I do not know how to do the same with the multiselect list boxes. I found code to write the selected list box values to a single cell and even insert a comma as a delimiter. Example: I have a cell that reads “201, 203, 207.” Each is a selection from Listbox1. For users to update this record, I need to pass these selections back to the user form. How do I get user form to understand that it should tick these three items in Listbox1?

 

[6StringJazzer]

I don't see anything in this code that updates any cell values. I'm stumped. If you can figure out a way to share your file I'm willing to troubleshoot it.

 

[NorthbyNorthwest]

Thanks, Jeff. See spreadsheet below.

Audit Tracker Project.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O																							AL	AM	AN	AO	AP
7	Employee Data
8	Employee	Position	Review Status	Unit	Supervisor	Audit Month	Audit Type	Audit Number	Date Audited by QA	Date Worked by Employee	Client's Last Name	File Number	ID	Page Count																							Err1	Err2	Err3	Err4	Err5
9	Bambi	Clerical Assistant	Audit	2	JamesL	April	1A	1	4/26/2021	4/23/2021	Anybody	000123789	743211																								100, 101, 102	-	301, 304, 305	402	-
10	Jiminy Cricket	Clerical Assistant	Audit	3	WesleyT	April	1A	1	4/23/2021	4/23/2021	Somebody	222000555																									100	200, 201	303	400, 401, 402, 403	501
11	Gaston	Mail Analyzer	Audit	12	DavisC	April	1A	1	4/26/2021	4/23/2021	Peabody	764893292																									101, 102	200, 201, 202, 203	-	-	-
12	Flower	Clerical Assistant	Audit	7	JohnsonC	April	1A	1	4/26/2021	4/26/2021	Nobody	333333333																									-	-	300, 301, 303, 305	400	-
13	Mickey Mouse	Senior Clerical Assistant	Audit	18	StanleyK	April	1A	1	4/26/2021	4/26/2021	Everybody	456321456																									100, 101, 102	-	-	-	-
14	Donald Duck	Clerical Assistant	Audit	1	HenryJ	April	1A	1	4/27/2021	4/27/2021	Who	098654321																									-	201, 202, 203	300, 302, 305	402	-
Audit Details

Cells with Data Validation
Cell	Allow	Criteria
J9:K14	Date	>=10/1/2020
M9:M205	Text length	between 4 and 9
N9:N205	Text length	between 5 and 10

 

[NorthbyNorthwest]

I don't see anything in this code that updates any cell values. I'm stumped. If you can figure out a way to share your file I'm willing to troubleshoot it.

I don't know how to send the actual workbook.