Userform - Label

  • Thread starter Thread starter Looping through
  • Start date Start date
L

Looping through

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
 
I must have this in the wrong spot.

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

I have to click on the lable in order for it show up in my userform.
 
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_Ref")
Quote_Form.RFQ_Ref.Caption = strTemp
End Sub

If this post helps click Yes
 
Back
Top