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.

hi
something like this maybe.....
Label1.Caption = Range("G29").Value

regards
FSt1

"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.

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.

I must have this in the wrong spot.

Private Sub RFQ_Ref_Click()
Quote_Form.RFQ_Ref.Caption =
ActiveWorkbook.Sheets("Configurator").Range("RFQ_R ef")
End Sub

I have to click on the lable in order for it show up in my userform.

"Jacob Skaria" wrote:

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.

Place a command button and place the code in command butoon click to try out..

Private Sub CommandButton1_Click()
Dim strTemp as Variant
strtemp = ActiveWorkbook.Sheets("Configurator").Range("RFQ_R ef")
Quote_Form.RFQ_Ref.Caption = strTemp
End Sub

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


"Looping through" wrote:

I must have this in the wrong spot.

Private Sub RFQ_Ref_Click()
Quote_Form.RFQ_Ref.Caption =
ActiveWorkbook.Sheets("Configurator").Range("RFQ_R ef")
End Sub

I have to click on the lable in order for it show up in my userform.

"Jacob Skaria" wrote:

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.