Hiding and displaying Listboxes through VBA

[gjp55]

Hi , I have a worksheet that has multiple different listboxes of which at any point will have 3 displayed and the rest hidden (to stop the worksheet looking cramped). This works fine and to display other list boxes, will hide all listboxes and then only display the ones allocated to that button. What I do have though is when I click the button, the listboxes that I want displayed flash for a second in another part of the screen then correctly display in the right position. The listboxes are displayed in the same positions (for example, sales section has 3 listboxes which are displayed when the sales button is selected and have vba to position them in the right positions and the Time section displays 3 listboxes in the same positions as the sales listboxes when selected hiding the Sales listboxes).

Is there a way to stop the listboxes flashing up before they are displayed in the correct position ? - or is this something that just happens when using this sort of functionality ?

Thanks
GJP

 

[doofusboy]

To avoid the 'flashing' you could try putting Application.ScreenUpdating = False before your listbox code and then Application.ScreenUpdating = True after your listbox code.

 

[gjp55]

Hi Doofusboy,
That didn't work unfortunatley for the listbox issue and still flashes up however, it did resolve another issue I have been working on so thanks very much for your help.