View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mallick Mallick is offline
external usenet poster
 
Posts: 17
Default Time Delay Between Execution of Two Functions

Hi Every One

There are two user defined VBA functions in my Excel sheet. The logic is
such that it requires the functions to be executed in a sequence. For
example. Function A should run and then Function B should be executed.
However, Excel fires both functions simultanously, causing problems.

One possible solution that comes to my mind is a time delay of a fraction of
second for Function B. In this way, Function A can be executed before
Function B. Can any one help me how to achieve this?

Or Alternatively, if you have got some other option, please share it with me.

Many Thanks

Mallick