View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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