I have been searching forums and the web for an answer to this with no luck so far. I have an add-in that I would like to add a report popup for. I am using a userform to make this report. I want to use a cell value that changes once daily to populate. When I run the userform, the values do not show up. they just show "lable1".
I don't understand why the values are not showing up. Any help or insight would be greatly appreciated.Private Sub Label8_Click() Label8.Caption = Worksheets("W G S").Range("K48").Value Label9.Caption = Worksheets("W G S").Range("K54").Value Label10.Caption = Worksheets("W G S").Range("K56").Value Label11.Caption = Worksheets("W G S").Range("K58").Value Label12.Caption = Worksheets("W G S").Range("K46").Value Label13.Caption = Worksheets("P A R").Range("Q24").Value Label14.Caption = Worksheets("P A R").Range("S24").Value End Sub
Thanks,
Rob
Bookmarks