View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BillCPA BillCPA is offline
external usenet poster
 
Posts: 101
Default Form Updating during Execution

Is there any way to keep the fields on a form from changing while code is
executing? If I have code that executes 1000 times and changes the data in
the fields on the form with each loop, but I only want the screen data to
show the change every 50 executions, do I have to do a .Hide and .Show, or is
there some other way to accomplish that?

My objective is to speed up execution, and my assumption is that each time a
field on the form changes, the entire form is refreshed - is that correct?

--
Bill @ UAMS