Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
========================
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Frame | Excel Programming | |||
about frame and screen shot of a frame | Excel Programming | |||
Frame | Excel Programming | |||
frame | Excel Discussion (Misc queries) | |||
How to attach legend frame to chart frame? | Charts and Charting in Excel |