Lable caption base on last entry in column

[asyamonique]

Me.Label15.Caption = Format(Sheets("list").Range("H1").Value, "###,##0")

Hello
I have a userform and Label15 caption shows the H1 cells data at worksheet"list"
Is there any way to change that code will look column H and last entry will populate at Label15 always?
Thanks

 

[Fluff]

How about

   Me.Label15.Caption = Format(Sheets("list").Range("H" & Rows.Count).End(xlUp).Value, "###,##0")