Preselect Listboxes based on Option button selection

Hi there

Please see the attached below.

A few things to sort if I may

How do I get the listboxes to pre-populate based on the Userid and Option Button selection? Furthermore, write back to the correct cell once the selection has been made?

How can I get the combobox to remove blanks in the Userid? (if each cell in row2 has to be populated then so be it)

ToolMatrix3.xlsm

Thanks
Biffer

Tinbendr - that's great, thanks for your time

I eventually got there using a load of IF statements, but your approach is much more efficient.

Thanks