OK, I think I have the code pasted in the right areas. When I try to run the userform, I get an error that I don't understand. I modified your code like this:
Code:
xlFillList ListOrComboBox:=Me.LabMarkingsComboBox, _
iColumn:=1, _
strWorkbook:="C:\Users\Public\Documents\FA worksheet changes\Word Worksheets\Dropdowns.xlsm", _
strRange:="LabMarkings", _
RangeIsWorksheet:=True, _
RangeIncludesHeaderRow:=True
This references a named range in my excel workbook called "LabMarkings". But the error I get is "Run-time error '-2147467259 (80004005)': 'LabMarkings$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long."
I'm not sure where it's adding the $ symbol? I assume that's the problem?