View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
external usenet poster
 
Posts: 618
Default looping through userform controls

Hi Dave

i can't see my first post .. however i did see Libby's & Bob's replies as
individual posts - don't quite know what's happened with this.

Thanks
JulieD

"Dave Peterson" wrote in message
...
You have a couple of replies at your first post. And one from libby
disconnected from that thread--in my newsreader program at least.)

JulieD wrote:

Hi All

i'm trying to (Excel 2000) loop through userform controls which are set

to
enabled = false & locked = true to change them to enabled = true and

locked
= false on the On Click of a command button.

I have John Walkenbach's book (excel 2002) where he shows code for

looping
through controls but i can't seem to find a way to get to either the

enabled
or locked properties - everything i tried resulted in excel crashing !

Help!

Thanks
JulieD


--

Dave Peterson