redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
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
Note: I have this code placed into the vb part of the actual Userform
Thanks in advance, and forgive my memory
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
VBA Code:
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