Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox's, .Enabled and .Visible do not work
I do not see why this will not work.
'================ If CheckBox1 = True Then ListBox1.Visible = False 'Use Visible or Enabled, neither work 'code here end if '============= When this works fine '============= If CheckBox1 = True Then CheckBox2.Visible = False CheckBox3.Visible = False End If '============= Thanks in advance! -- Regards Rick XP Pro Office 2007 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox's, .Enabled and .Visible do not work
Rick S,
If on a form try Userform1.listbox1.visible=false If on a worksheet then Sheets("sheet1").listbox1.visible=false "Rick S." wrote: I do not see why this will not work. '================ If CheckBox1 = True Then ListBox1.Visible = False 'Use Visible or Enabled, neither work 'code here end if '============= When this works fine '============= If CheckBox1 = True Then CheckBox2.Visible = False CheckBox3.Visible = False End If '============= Thanks in advance! -- Regards Rick XP Pro Office 2007 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox's, .Enabled and .Visible do not work
Yes it is on a Form and "Userform1.listbox1.visible=false" did not work either?
I can use the toolbox, set the visible value to False then load the form and it is not visible. I just can't do it in a macro. On the opposite side, I can not make the listbox visible if I turn it off from the toolbox. Crazy man! The whole world is crazy! -- Regards Rick XP Pro Office 2007 "JRForm" wrote: Rick S, If on a form try Userform1.listbox1.visible=false If on a worksheet then Sheets("sheet1").listbox1.visible=false "Rick S." wrote: I do not see why this will not work. '================ If CheckBox1 = True Then ListBox1.Visible = False 'Use Visible or Enabled, neither work 'code here end if '============= When this works fine '============= If CheckBox1 = True Then CheckBox2.Visible = False CheckBox3.Visible = False End If '============= Thanks in advance! -- Regards Rick XP Pro Office 2007 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox's, .Enabled and .Visible do not work
Problem solved!
I simply had to pull my head from out of my behind! The code was in the wrong part of the macro to know when the event occured. Please keep the laughter to a dull roar, I still have work to do! ;) -- Regards Rick XP Pro Office 2007 "Rick S." wrote: I do not see why this will not work. '================ If CheckBox1 = True Then ListBox1.Visible = False 'Use Visible or Enabled, neither work 'code here end if '============= When this works fine '============= If CheckBox1 = True Then CheckBox2.Visible = False CheckBox3.Visible = False End If '============= Thanks in advance! -- Regards Rick XP Pro Office 2007 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox's, .Enabled and .Visible do not work
Who's laughing, I've been there myself. I'm cheering for you.
"Rick S." wrote: Problem solved! I simply had to pull my head from out of my behind! The code was in the wrong part of the macro to know when the event occured. Please keep the laughter to a dull roar, I still have work to do! ;) -- Regards Rick XP Pro Office 2007 "Rick S." wrote: I do not see why this will not work. '================ If CheckBox1 = True Then ListBox1.Visible = False 'Use Visible or Enabled, neither work 'code here end if '============= When this works fine '============= If CheckBox1 = True Then CheckBox2.Visible = False CheckBox3.Visible = False End If '============= Thanks in advance! -- Regards Rick XP Pro Office 2007 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Listbox's not working | Excel Programming | |||
ThisWorkbook.Saved = True does not work when Shapes().ControlFormat.Enabled = False | Excel Programming | |||
Visible rows and functions that work | Excel Worksheet Functions | |||
Listbox's and retaining data when closing | Excel Programming | |||
LISTBOX'S | Excel Programming |