VBA中的同步和异步方法是什么？ [英] What are the synchronous and asynchronous methods in VBA?

问题描述

我在网上搜索过但找不到我这个问题的任何答案。有没有人知道在哪里找到它，或者有这样的列表。

例如：Workbook.RefreshAll是异步的，而Application.Calculate是同步的。

但是，当然我只对可能影响结果的方法感兴趣，如果它是异步的而不是同步的，反之亦然。例如：我对Range的Autofill方法不感兴趣。它肯定是同步的，等到自动填充到
完成后再转到下一行代码。

---

在你口渴之前挖好你的

解决方案

您好ExcelinEFendisi，

正如您所发现的，我也试图找到，我恐怕没有这样的列表告诉我们哪种方法是异步的，哪种方法是同步的。

b

最诚挚的问候，

爱德华

Hi,

i've searched through the net but couldn't find any answer to this question of mine. does anyone know where to find it, or have any list like this.

e.g: Workbook.RefreshAll is asynchronous whereas Application.Calculate is synchrous.

But of course i'm only interested in the methods which may affect the results if it were asynchronous rather then synchronous, vice versa. e.g: i'm not interested in Autofill method of Range. it is certainly synchronous and waits for the autofill to finish before going to next line of the code.

---

Dig your well before you are thirsty

解决方案

Hi ExcelinEFendisi,

As you have found, and I also tried to find, I am afraid there is no such list to tell us which method is async and which method is sync.

Best Regards,

Edward

这篇关于VBA中的同步和异步方法是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！