ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Frame (https://www.excelbanter.com/excel-programming/412647-frame.html)

ranswrt

Frame
 
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

Susan

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




All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com