View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default Work with only objects in a frame...

i use something like this to reset all of the option buttons in frame2 on
userform1, maybe it will give you an idea

Dim cntrl As Control
For Each cntrl In UserForm1.Frame2.Controls
If cntrl.Value = True Then
cntrl.Value = False
End If
Next

--


Gary


"SupperDuck" wrote in message
...
Hello all,

Just guess that i have 10 combobox... 5 in frame1 and the other 5 in frame2.

Well, i want to do something like...

code..
dim a as combobox
for each a in frame1

a.enabled = false

next

I must do something more, may be select all objects not only comboboxes or
may be do sth.

But i do not now how to do only the objects which is in the frame that i
want...

Is there a way?

Thanks..