Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I think I may have asked this before, but I can't find the post. I have a userform with a mixture of control on it. I want to set the visible property of all the images to false How do I loop through the controls and make only the images invisible? My current code makes all the controls invisible. Many thanks in advance. Libby x |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Libby,
Here is some code that will work from within the userform module Dim ctl As Control For Each ctl In Me.Controls If TypeOf ctl Is Image Then ctl.Visible = True Else ctl.Visible = False End If Next ctl -- HTH RP (remove nothere from the email address if mailing direct) "Libby" wrote in message ... Hi, I think I may have asked this before, but I can't find the post. I have a userform with a mixture of control on it. I want to set the visible property of all the images to false How do I loop through the controls and make only the images invisible? My current code makes all the controls invisible. Many thanks in advance. Libby x |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Problem: Control Toolbox Control resizes when clicked | Excel Programming | |||
Looping through controls on a MultiPage control | Excel Programming | |||
Set Focus Problem for textbox control on multipage control | Excel Programming | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming |