Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Define you variable in a general module at the top (insert=Module)
Public MyVar as String Sub SetMyVar() myVar = "ABCD" End sub then in the Userform Module Private Sub Userform_Initialize() me.Caption = MyVar End Sub -- Regards, Tom Ogilvy "Alvin Hansen" wrote in message ... Hi Can i use a variabel in my caption in my userform sp the titel in my userform have the value of my variabel and if i can how? And where shall i define my variabel? Best regards Alvin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Load caption box on userform open | Excel Worksheet Functions | |||
Defining UserForm Caption from a Variable | Excel Worksheet Functions | |||
Visual basic Userform caption | Excel Programming | |||
Userform - Label Caption - How to update from a variable | Excel Programming | |||
UserForm Caption | Excel Programming |