Code:
[FONT=Arial]Private Sub UserForm_Initialize()[/FONT]
[FONT=Arial]With Sheet8[/FONT]
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
[FONT=Arial]Label1.Caption = " " & Sheet8.Range("A3").Text & " - " & Sheet8.Range("L3").Text<o:p></o:p>[/FONT]
[FONT=Arial]Label2.Caption = " " & Sheet8.Range("A4").Text & " - " & Sheet8.Range("L4").Text<o:p></o:p>[/FONT]
[FONT=Arial]Label3.Caption = " " & Sheet8.Range("A5").Text & " - " & Sheet8.Range("L5").Text<o:p></o:p>[/FONT]
[FONT=Arial]Label4.Caption = " " & Sheet8.Range("A6").Text & " - " & Sheet8.Range("L6").Text[/FONT]
<o></o>
I wish I could leave labels blank... If Cells in Sheet 8.Range L = 0
Thanks