Excel在执行期间从宏输出到工作表。 [英] Excel output to sheet from macro during execution.

问题描述

我有一个宏，它根据用户输入控制多个子程序的执行。该过程需要子程序的内部迭代（而不是电子表格迭代）。

如何强制控制子程序将中间值输出到电子表格而不中断过程？

我有子程序每次迭代都执行以下语句但是在计算完成之前，表格上没有任何内容。 " outsht"已定义。

   表格（outsht）.Cells（25,11）= iter

我希望这向用户显示它实际上正在运行，因为可能需要10-15分钟才能完成所有计算。

感谢您对此问题的任何帮助。

Joan

解决方案

< blockquote>

我有一个宏，它根据用户输入控制多个子程序的执行。该过程需要子程序的内部迭代（而不是电子表格迭代）。

如何强制控制子程序将中间值输出到电子表格而不中断过程？

我有子程序在每次迭代时执行以下语句，但在计算完成之前没有任何内容显示在工作表上。 " outsht"已定义。

   表格（outsht）.Cells（25,11）= iter

我希望这能向用户显示它实际上正在运行，因为它可能需要10 -15分钟完成所有计算。

感谢您对此问题的任何帮助。

Joan

I have a macro that controls execution of multiple subroutines based on user input. The process requires internal iteration of the subroutines (not spreadsheet iteration).

How can I force the control subroutine to output intermediate values to the the spreadsheet without interruption of the process?

I have the subroutine executing the following statement every iteration but nothing shows on the sheet until the computation is complete. "outsht" is defined.

    Sheets(outsht).Cells(25, 11) = iter

I would like this to show the user that it is actually running as it may take 10-15 minutes to complete all calculations.

Thanks for any help with this question.

Joan

解决方案

I have a macro that controls execution of multiple subroutines based on user input. The process requires internal iteration of the subroutines (not spreadsheet iteration).

How can I force the control subroutine to output intermediate values to the the spreadsheet without interruption of the process?

I have the subroutine executing the following statement every iteration but nothing shows on the sheet until the computation is complete. "outsht" is defined.

    Sheets(outsht).Cells(25, 11) = iter

I would like this to show the user that it is actually running as it may take 10-15 minutes to complete all calculations.

Thanks for any help with this question.

Joan

这篇关于Excel在执行期间从宏输出到工作表。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！