populate worksheet from combobox?

[thehustler]

Morning folks, long time lurker - this site has provided me with some great help over the years

I am looking for some help with a formula whereby I have a list of place names in a combo box in a userform, and when selected I want it to automatically read from an address block (it's a named range) I have on a worksheet and copy this text to a specified cell on another sheet?

for example:

If cboFrom = "Office1" Then
    Sheets("Letter").Cells(2, 1) = Sheets("lists").Range("OfficeAdd1")
    Else
    Sheets("Letter").Cells(2, 1) = Sheets("lists").Range("OfficeAdd2")
 End If

Can anyone help point me in the right direction please?

 

[thehustler]

Is anyone able to help at all please?