Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Upon initializing, I need to set the visible property for
all images on a user form (named "Game") to false. Having trouble. Thx. Jason |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
A very easy way is to do that while you're still in design mode... just
select them all, and set the Visible property to False. -- Regards, Juan Pablo González "Jason Morin" wrote in message ... Upon initializing, I need to set the visible property for all images on a user form (named "Game") to false. Having trouble. Thx. Jason |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dim ctrl as Control
for each ctrl in Game.Controls if typeof ctrl is MSForms.Image then ctrl.Visible = False end if Next -- Regards, Tom Ogilvy "Jason Morin" wrote in message ... Upon initializing, I need to set the visible property for all images on a user form (named "Game") to false. Having trouble. Thx. Jason |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Jason,
As Juan Pablo noted, you can accomplish this at design time. Here's how you could do it at runtime: Private Sub UserForm_Initialize() Dim ctl As Control For Each ctl In Controls If TypeOf ctl Is MSForms.Image _ Then ctl.Visible = False Next ctl End Sub -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Jason Morin wrote: Upon initializing, I need to set the visible property for all images on a user form (named "Game") to false. Having trouble. Thx. Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cycle through images on UserForm | Excel Discussion (Misc queries) | |||
Global value does not retain value when UserForm is hide | Excel Programming | |||
Userform.hide / show | Excel Programming | |||
Hide/Show modeless userform when activating/deactivating workbooks | Excel Programming | |||
hide a textbox on a userform? | Excel Programming |