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