Display Text & value of Cell on Userform

[Lexian]

Hi,

I have a UserForm and a Label. When the Userform is open. I want the Label to Display:

"Welcome to Mining Matrix"

but the word Matrix comes from different Worksheet. so meaning you can change the word matrix from that sheet.


Thanks in advance

 

[Vbagreenhorn1]

something like this?

Private Sub UserForm_Initialize()
Label1.Caption = "Welcome to Mining " & Sheets("Sheet1").Cells(1, 1).Value
End Sub

 

[Jan Mach]

1. Give some understandable name to Label1, say, Grt (like greeting); don't use anonymous names like CommandButton138, Label17, ...
2. Put the constant text "Welcome to Mining " on Grt (put it in the Caption property)
3. Give a name to the cell A1 in Sheet1, say, mtrx; don't use absolute as-long-as-Mississippi references.
Then

Private Sub UserForm_Initialize()
Grt = Grt & [mtrx].Text
[COLOR=#008000]'Use benefits of default properties; the Caption property is the default one for labels.
'Use the Text property when you need string, not the variant Value[/COLOR]
End Sub