Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variabel and caption in userform
Alvin,
Assuming the title you want to use is in cell A1... In the form module, put the following. '/====================================/ Private Sub UserForm_Activate() Me.Caption = Application.ActiveSheet.Range("A1").Value End Sub '/====================================/ HTH, Gary Brown -----Original 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Load caption box on userform open | Excel Worksheet Functions | |||
Defining UserForm Caption from a Variable | Excel Worksheet Functions | |||
Variabel and caption in userform | Excel Programming | |||
Variabel and caption in userform | Excel Programming | |||
UserForm Caption | Excel Programming |