Thread: Frame
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default Frame

========================
if frame1.enabled=false then
optionbutton1.enabled=false
optionbutton2.enabled=false
optionbutton3.enabled=false
end if
========================
OR you could set the controls within the frame to have a group name
and then make all the controls with that group name un-enabled.

for instance:
======================
Dim oControl as Control

If oControl.GroupName = "Unseen" then
oControl.enabled=false
end if
=====================
hope it helps
:)
susan


On Jun 16, 9:45*am, ranswrt wrote:
Is there a way that I can set a frame in a userform enabled to false and the
objects inside the frame also will automatically be set to false also?
Thanks