Add background colour to ListBox item(s) that have been selected...

[Matty]

Hi Team,

I have a UserForm ListBox that is populated via a SQL connection. When a value is selected, a delimited string containing the selected values is created in a cell on a spare worksheet.

I would like the background colour of the ListBox item to be a different colour if it exists within the string held on the spare sheet mentioned above.

Can this be done?

Thanks,

Matty

 

[Matty]

Glad to help.

Any suggestions on the below, Rory?

https://www.mrexcel.com/forum/excel-questions/1029429-listbox-population-problem.html

Cheers,

Matty