mvar = Userform1.Label1.Caption
msgbox mvar

--
Regards,
Tom Ogilvy

"Roger" wrote in message
...
I have a Userform with numerous Lables whose captions change depending on
....
a coresponding textbox is then enabled true or enabled false - it takes a
load of code to do this - I have tried to store the lable names in a
variable
which will reduce code ... but always get the error message "member not
found"

question - how do I store a userform lable name in a variable - thankyou
in
anticipation
--
Roger