Listbox visible false

[jeffmoseler]

I am trying to use code to hide a listbox. This is what I have so far, but it's not working. I know the answer is simple but I can't remember. Thanks for the help.

ActiveSheet.Shapes("ListBox1").Visible = True
ActiveSheet.RefreshAll

 

[jeffmoseler]

Good call. I just tried that and it still does the same thing.

The listbox is from the control tool box as opposed to the forms toolbox. When I try to set the visible property value to false it gives me these issues.

 

[sous2817]

I don't think it's an Excel issue, but maybe a hardware (video card / video chip) issue. On both my home and work computers I don't have an issue w/ the combo box disappearing and reappearing by just running the code, not having to "refresh" the screen by selecting another worksheet.

 

[jeffmoseler]

I think I found the issue. I wasn't using a command button. I was using a picture and assigning it a macro. If I use a command button it works fine.

Does anyone know why?