Make Excel wait

So I have some line of code:

Please Login or Register  to view this content.

After the above event occurs, I want excel to wait 2-3 seconds to finish updating it's DDE-links. It's vital that all Excel functions keep running as normal while this wait is occuring, then run this line of code:

Please Login or Register  to view this content.

Can something like this be done? I seem to remember when forcing Excel to wait everything just seems to stop dead.

First try Wait............from VBA Help:

Please Login or Register  to view this content.

But if DDE is suspended during the wait, use an OnTime Event macro.

Hi, I tried Application.Wait (Now + TimeValue("0:00:1")), unfortunately everything including DDE gets suspended. For more context of what I'm looking to do, my Excel autosubmits an order via DDE to a trading platform when a condition is met. The condition relies on information from my current portfolio fed into Excel via DDE. After the order is filled, there is around a one second delay until the portfolio information updates in Excel and includes my most recent order. The problem I'm having, is that the portfolio information is part of the condition responsible for autosubmitting the order in the first place, and unless it's updated immediately upon the order being filled, it will keep autosubmitting orders until the DDE link updates with the new portfolio information and the condition becomes inactive.