ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problems with listboxes in connection with screenupdating = false (https://www.excelbanter.com/excel-programming/378219-problems-listboxes-connection-screenupdating-%3D-false.html)

Mats Nilsson

Problems with listboxes in connection with screenupdating = false
 
Hi all,
In a sheet with listboxes (Placement = xlMoveAndSize) I have different
row-intervals either hidden or not hidden depending on users selection of
alternatives. The listboxes should also be visible or not visible following
the row interval. When running VBSa routine with screenupdating = false there
will be problems to get the listbox visible when the routine is finished and
screen updating is changed to true.

In other models I have got other problems like this so I appreciate any
comment or help how to best handle these problems.

All the best.
Mats

--
ESI Update


All times are GMT +1. The time now is 11:34 PM.

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