let's say i have some code as follows:


Code:
--------------------
If ComboReg.Value = "National" Then
ListNat.Visible = True
ListE.Visible = False
ListW.Visible = False
ListC.Visible = False
ListS.Visible = False
--------------------


is there any way to group the different lists so that i only need to
write .visible = false once? maybe something like
(liste,listw,listc,lists).visible = false.

what about for with-end with constructions? is there a way i can
write:


Code:
--------------------
with (liste,listw,listc,lists)
insert code
end with
--------------------


or something to that effect?

thanks.


--
dreamz
------------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...o&userid=26462
View this thread: http://www.excelforum.com/showthread...hreadid=521145