UserForm and Cell Data to ListBox

Hello!

I am creating a UserForm that is used to add a new entry or edit an existing entry in a worksheet. The last tackle is the ListBox. The ListBox contains a number of comment codes, pulled from a table in a different worksheet.

I assigned a variable to aid in getting the selected data in the UserForm's ListBox (there are actually 3) to the cell in the appropriate column in the worksheet when a new entry is created.

How do I go about retrieving the data from this cell and select all matching option codes in the ListBox?
If I go to edit an entry in the table using the UserForm, I want these codes to highlight in the UserForm ListBox so I can make easy changes. Something like this.

Screenshot 2023-10-31 220327.png

Thanks!

See big yellow banner - How to upload your workbook - far easier then to give you a solution - we can not manipulate pictures.

Torachan: Thanks for the push to upload the workbook. I should've just done it from the get.

All: Thanks in advance for the help. The 'UserForm File' workbook is uploaded. I obviously had loads of changes to make to it prior to posting. I kept the important code to help streamline reaching a solution, deleted the rest, and left a couple comments in the code.

I very much look forward to completing this project. I'm not a developer or Excel master by trade, but this is something I took on to help manage a database which is now becoming very large. I got this far! I look forward to everyone's take on a solution.

Give the attached a trial - using separate userforms creates extra work transferring variables/data across (need to use public variables etc.) - if you still want to keep separate use a second page of the multipage you have already put on your form(this will give you the same effect as a second form but will keep all the variables in the same userform app.
Using the combobox to select your data for Updating/Deleteing there is no need for search routines as there is a direct link between the .listindex and the table row (you will see a variable 'sc' - as the variables are declared at the head of the code immediately after Option Explicit they are then available across all Subs - if declared within a Sub they are specific to that Sub).
To add a new record first press 'CLEAR', this ensure the form is clear and activates the 'ADD' button - enter your data when complete press 'ADD' - the other buttons should be intuitive.
If you need further help post back in this thread.

glad to have helped - thanks for the added rep point.