Thread: Screen updating
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E[_2_] AA2e72E[_2_] is offline
external usenet poster
 
Posts: 93
Default Screen updating

If at all, ScreenUpdating should be set to TRUE, not FALSE

You must have a UserForm1.Show i.e a SHOW statement somewhere, to make the form visible. AFTER that statement, add a line DoEvents; this might resolve it.