userform initalise - auto fill label box

[redspanna]

Hi all

Simple, but can't remember how

I have some code that will select (and copy) the entire row of a selected cell
This copied data is pasted into Row1 of "Data" sheet and the userform displayed....

I want my Userform to be displayed and with the value of cell C1 in the Data sheet in the label1 position

I have this code, but can't seem to get it to work

Private Sub userform_initialize()
Label1 = Sheets("Data").Range("C1").Value

End Sub

Note: I have this code placed into the vb part of the actual Userform

Thanks in advance, and forgive my memory

 

[redspanna]

Label1.Caption = Sheets("Data").Range("C1").Value

I believe should work...just figured it out