Userform.Lable Variables
Yeh, I got my A's and C1's confused I guess.
Thanks.
--
Regards,
Tom Ogilvy
"Dave Peterson" wrote in message
...
I think you may have meant:
UF1.Controls(A).Enabled = True
or
UF1.Controls("C1").Enabled = True
Tom Ogilvy wrote:
UF1.Controls(C1).Enabled = True
--
Regards,
Tom Ogilvy
"Roger" wrote in message
...
Tom - thanks but its not the caption text I want to store in a
variable
...
its the actual Lable name IE
C1 is the name of a lable in a userform called UF1
if I write
UF1.C1.Enabled = True
all OK
if I write
A = "C1"
UF1.A.Enabled = True
I get the error message "member not found"
please tell me how to write this properly
--
Roger
"Roger" wrote:
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
--
Dave Peterson
|