Userform label

N

Need help

How is a userform label caption programmed to read "Blah
blah blah" & some variable (or cell value)? XL97.

TIA
 
H

Harald Staff

In the Userform code module:

Private Sub UserForm_Initialize()
Label1.Caption = "Blah blah blah " & _
Sheets(1).Range("A1").Text
End Sub
 
Top