CONTROLLERS_INITIALS = "ABC"
Label1.Caption = "What Shift for " & CONTROLLERS_INITIALS

Should work.

Depending on where the code is located, you might need to qualify Label1

Userform1.Label1.Caption =

or

Sheet1.Label1.Caption =

as examples.

Regards,
Tom Ogilvy



Rod Taylor wrote in message
. ..
Can I add a variable to the caption of a label on a form

i.e. Label1.Caption = ("What Shift for" & CONTROLLERS_INITIALS)

where CONTROLLERS_INITIALS is a variable