User Form Captions

[Chillywilly76]

I am looking for a way to use the value in a cell as a caption on a user form. Any help would be appreciated.

[Norie]

Something like this?

UserForm1.Caption = Worksheets("Sheet1").Range("A1").Value

[Chillywilly76]

Thanks, but where would I put that code? and if I name that cell could I save some typing?

[Norie]

In the form's Initialize event perhaps.

Private Sub UserForm_Initialize()  
   UserForm1.Caption = Worksheets("Sheet1").Range("A1").Value
End Sub

You could name the cell if you wanted and it would save a few keystrokes.

[Chillywilly76]

Norie, Thanks for the help and this is what I have written.
addplayerf = form
asquare = name of the label in addplayerf form I am trying to get to change
sasquarename = named cell I am trying to reference

Private Sub addplayerf_Initialize()

   asquare.Caption = "sasquare"
   
End Sub

[Norie]

Don't change Userform_Initialize.

If 'sasquare' is a named range you need Range("sasquare"l.