ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Screenupdating Problems (https://www.excelbanter.com/excel-discussion-misc-queries/85790-screenupdating-problems.html)

Trent

Screenupdating Problems
 
In some code I want to turn off screenupdating. The code is triggered
by clicking on an element of a listbox that is in the sheet. It would
seem that if screenupdating is used during the triggered code the
listbox will not visually update itself. I know this is the case
because if I click elsewhere in the sheet it then decides to update the
listbox to selections I made previously.

This is the listbox from the control toolbox.

Just curious if anyone has a way around this particular problme.



All times are GMT +1. The time now is 05:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com