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!
Bookmarks