View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Trent
 
Posts: n/a
Default 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.