Userform1.Label1.Caption = ActiveWorkbook.Sheets("Sheet1").Range("A1")

In your case


Quote_Form.RFQ_Ref.Caption = ActiveWorkbook.Sheets("Sheet1").Range("RFQ_Ref")


If this post helps click Yes
---------------
Jacob Skaria


"Looping through" wrote:

How do you insert the value of a certain cell ("G29"; range named "RFQ_Ref")
into a lable (RFQ_Ref) in a userform (Quote_Form)

I have searched but just can't find it.