Lable name

[zJenkins]

Hi al,

For some reason I can’t seem to get this to work.

I’m trying to set the caption of a userform label based on acell value. I’m using the following VBA

Private Sub UserForm1_Initialize()

[COLOR=#1f497d][FONT=Calibri][FONT=Calibri][SIZE=3]lbl_date.Caption =Sheets("August").Range("A3").Value[/SIZE][/FONT][/FONT][/COLOR]
[COLOR=#1f497d][FONT=Calibri][FONT=Calibri][SIZE=3]End Sub
[/SIZE][/FONT][/FONT][/COLOR]

The label name and sheet name are correct and it’s in theUserform1 code. Any help would begreatly appreciated.

Thanks!

 

[Norie]

It should be UserForm_Initialize not formname_Initialize.

 

[zJenkins]

It should be UserForm_Initialize not formname_Initialize.

Haha, so simple...thanks!