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

Thank you thank you all
It was a message box where the user shal write there name
and the name shall stand i the titel off my userform
and yes its working Wooooooooooow
Off course the best soloution would bee to take there user name
the have use to get on to the pc, but i don't believe i can do that

Many thanks

Alvin


"Tom Ogilvy" skrev:

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