PDA

View Full Version : Solved: Hide a list box (form controls)



YasserKhalil
10-29-2010, 04:54 AM
Hi everybody
I have a list box which is a form control.. I try to hide it
Here's my code
Activesheet.Controls("List Box1").Visible=False
But I got error

Bob Phillips
10-29-2010, 05:13 AM
ActiveSheet.ListBoxes("List Box 1").Visible = False

YasserKhalil
10-29-2010, 05:23 AM
Thank you very much
I tried this code but as follows
ActiveSheet.ListBoxes("List Box1").Visible = False
It's just the space which caused the erro

kemas
11-12-2010, 02:57 PM
ActiveSheet.ListBoxes("مربع قائمة 1").Visible = False