Jex, why not just use one userform with a listbox that contains the
unprocessed orders? When the sales person changes the selection in the list
box, the information on the dialog changes, including a time remaining
message.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Jex " wrote in message
...
Hi,

This is my first post, sorry it is so long!

I am trying to build some customisation for an add-in my company is
trialling. The add-in receives an order from a server to which the
spreadsheet is linked, and adds a line to the worksheet showing the
relevant data - price, type, etc. The functionality in the addin allows
you to right click on an order and choose whether to accept or reject
it - this information is then sent back through the server.

So far so good. My problem is, we need to have a time constraint on the
accept/reject bit - if the order has not been accepted within 30
seconds of arriving, it must be automatically rejected.

I have created a userform that pops up, shows the details of the order,
and has a progress bar counting down, changing colour as it gets closer
to 30 seconds. Failure to click on the Accept or Reject button triggers
an automatic Rejection message, and also indicates that it was a
"TimeOut" rather than a deliberate rejection.

My problem is that there will be more than one order coming in within a
30 second timeframe. I need a box to pop up for each order that comes
in, with the "oldest" on top, all counting down. It is essential that
these messages be clear and visible (ie they can't be just cells on the
worksheet, the salesmen have lots of different windows and apps open
and this needs to be eyecatching). I have absolutely no idea how to do
this, and would really appreciate any help!

J


---
Message posted from http://www.ExcelForum.com/