N Need help Aug 7, 2003 #1 How is a userform label caption programmed to read "Blah blah blah" & some variable (or cell value)? XL97. TIA
How is a userform label caption programmed to read "Blah blah blah" & some variable (or cell value)? XL97. TIA
H Harald Staff Aug 7, 2003 #2 In the Userform code module: Private Sub UserForm_Initialize() Label1.Caption = "Blah blah blah " & _ Sheets(1).Range("A1").Text End Sub
In the Userform code module: Private Sub UserForm_Initialize() Label1.Caption = "Blah blah blah " & _ Sheets(1).Range("A1").Text End Sub