Labels and messages

  • Thread starter Thread starter rob nobel
  • Start date Start date
R

rob nobel

I have a UserForm with labels containing certain text.
What I would like to do is have one of the labels also display other text
depending on a formula in the worksheet. The formula that will display the
information is....
Worksheets("BAS").Range("T1").Text
But I don't know how to get the UserForm to show that value within a label.
Can someone please assist?
Rob
 
Hi Ron,
You probably need to refresh the form (repaint).

Form code.
Label1.Caption = "Hello " & Worksheets("BAS").Range("T1").Text 'show text
and variable
UserForm1.Repaint

Module code.
UserForm1.Label1.Caption = "Hello " & Worksheets("BAS").Range("T1").Text
UserForm1.Repaint
 
Back
Top