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

NorthbyNorthwest

Board Regular
Joined
Oct 27, 2013
Messages
78
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

Well-known Member
Joined
Jan 27, 2010
Messages
865
Office Version
  1. 365
Platform
  1. Windows
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.
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

NorthbyNorthwest

Board Regular
Joined
Oct 27, 2013
Messages
78
Thanks, Jeff. See spreadsheet below.

Audit Tracker Project.xlsm
BCDEFGHIJKLMNOALAMANAOAP
7Employee Data
8EmployeePositionReview StatusUnitSupervisorAudit MonthAudit TypeAudit NumberDate Audited by QADate Worked by EmployeeClient's Last NameFile NumberIDPage CountErr1Err2Err3Err4Err5
9BambiClerical AssistantAudit2JamesLApril1A14/26/20214/23/2021Anybody000123789743211100, 101, 102-301, 304, 305402-
10Jiminy CricketClerical AssistantAudit3WesleyTApril1A14/23/20214/23/2021Somebody222000555100200, 201303400, 401, 402, 403501
11GastonMail AnalyzerAudit12DavisCApril1A14/26/20214/23/2021Peabody764893292101, 102200, 201, 202, 203---
12FlowerClerical AssistantAudit7JohnsonCApril1A14/26/20214/26/2021Nobody333333333--300, 301, 303, 305400-
13Mickey MouseSenior Clerical AssistantAudit18StanleyKApril1A14/26/20214/26/2021Everybody456321456100, 101, 102----
14Donald DuckClerical AssistantAudit1HenryJApril1A14/27/20214/27/2021Who098654321-201, 202, 203300, 302, 305402-
Audit Details
Cells with Data Validation
CellAllowCriteria
J9:K14Date>=10/1/2020
M9:M205Text lengthbetween 4 and 9
N9:N205Text lengthbetween 5 and 10
 

Forum statistics

Threads
1,140,926
Messages
5,703,215
Members
421,282
Latest member
hogie

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top