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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Look Up 2
How do I do this??! 1
Remove last <li> entry from cells 17
Deactivating an Excel Warning 1
Formula to define non-contiguous range? 7
Invisible Text Boxes 1
Search the list of Ids in the records 1
Not sure what the subject is 2

Top