View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Userform.Lable Variables

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