Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
label caption
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
label caption
Rod,
I would have tried it by now, if I were me, and found it to work. The Caption property takes a string. You can assign any valid string to the Caption property - even a concatenated one. -- Bob Kilmer "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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
label caption
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
label caption | Excel Discussion (Misc queries) | |||
Is it a comment ? or a label ? or a caption ?.... | Excel Discussion (Misc queries) | |||
Linking Cell to Label Caption | Excel Worksheet Functions | |||
Link Cell to Label Caption | Excel Discussion (Misc queries) | |||
label caption equal excel value | Excel Worksheet Functions |