I am trying to fill a textbox with a value from a different worksheet.
I can seem to get it to work whichever way i write it.

Also is there a way I could reference this from a different (closed) workbook

TextBox1.value = Sheets("loadings").Cells(strRowNoList, 2)
Thanks in advance for any guidance.