Hi all,

I created a message box which gives a user a number of seconds to enter a selection before proceeding with certain code. Please see the following thread for the code / history on that one...

Timed Message Box

The problem I am experiencing now is that the macro only continues once the msgbox \ relevant Excel window is activated. This is an issue because most of the time the macro needs to run when no one is on the PC and even if there was someone sitting there manually activating the box is cumbersome and needless.

The troublesome code, I believe, is this bit:

On Error Resume Next
Answer = "myNoAnswer"
time_x = Now + TimeValue("00:00:05")
Application.OnTime EarliestTime:=time_x, Procedure:="counter_5", Schedule:=True
UserForm1.Show
Application.OnTime EarliestTime:=time_x, Procedure:="counter_5", Schedule:=False
Any thoughts or ways around (which do not involve activating the window even via VBA) this would be appreciated.