ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Form Updating during Execution (https://www.excelbanter.com/excel-discussion-misc-queries/104039-form-updating-during-execution.html)

BillCPA

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


All times are GMT +1. The time now is 02:29 PM.

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