VBcomponents is a whole pile more difficult than this needs to be. Add a
sheet and call it "Form Variables" or something like that... Now in the form
initialization add something like...

label1.caption = sheets("Form Variables").Range("A1").Value

For your button add
label1.caption = "MySting"
sheets("Form Variables").Range("A1").Value = "MySting"

Now the value of the label caption is stored in the sheet and it is
initialized at run time. if you don't want your users getting at the value
make the sheet very hidden
sheets("Form Variables").visible = xlVeryhidden


--
HTH...

Jim Thomlinson


"Soniya" wrote:

I am changing label1.caption by clicking commandbutton1.

I know code can be changed by using VBAProject.VBComponents.

but I could not get it to work in my case.

thanks