Hi Paul,
In the context of the document, what I've got is a Work Method Statement / Job Safety Analysis whereby each line of the table is a chronological step of how an activity or project will be completed safely. Part of the work analysis is determining hazards for each step by referring to a Risk Assessment Matrix. I'm hoping to simplify completion of the WMS / JSA whereby the user displays the Risk Assessment Matrix (which was my UserForm) and simply clicks the relevant hazard rating from that UserForm; in this case I was utilising Option Buttons for each type of hazard rating i.e. A0, A3, C5.
The result from the selected OptionButton would then populate the cell of the table they had clicked in to.

Does this help describe what I'm hoping to achieve? Would some additional screen shots help perhaps?

Thank you.