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

.