I would like to know about making a process Wait. I’ve learned how to
make it wait for a certain length of time or until a certain time of
day, but while it is waiting I cannot interact with Excel at all. If I
had a Message Box I could make it Modeless, but I want to do the same
thing without the Message Box. And how about waiting until a certain
condition is met? For instance, make it wait until a certain Cell’s
Value is changed.

Thanks in advance for the help. - Pikus


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

Since you complain that you can not work with Excel while waiting - then
what do you envision waiting to be?

What are you trying to achieve until a cell changes. If the user can
continue to work with Excel, what is limited to constitute waiting?

How are you making a msgbox modeless?

--
Regards,
Tom Ogilvy

"pikus " wrote in message
...
I would like to know about making a process Wait. I've learned how to
make it wait for a certain length of time or until a certain time of
day, but while it is waiting I cannot interact with Excel at all. If I
had a Message Box I could make it Modeless, but I want to do the same
thing without the Message Box. And how about waiting until a certain
condition is met? For instance, make it wait until a certain Cell's
Value is changed.

Thanks in advance for the help. - Pikus


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

Pikus,

I'm not entirely clear what you are looking for. Perhaps you
could provide a more detailed explanation of specifically what
you need. Maybe the Worksheet_Change event is what you need.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"pikus " wrote in message
...
I would like to know about making a process Wait. I've learned
how to
make it wait for a certain length of time or until a certain
time of
day, but while it is waiting I cannot interact with Excel at
all. If I
had a Message Box I could make it Modeless, but I want to do
the same
thing without the Message Box. And how about waiting until a
certain
condition is met? For instance, make it wait until a certain
Cell's
Value is changed.

Thanks in advance for the help. - Pikus


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

I am not getting you either but I think one really ugly suggestion woul
be something like this.


do until range("Whatever you want").value = "Your condition"

doevents

loop

''rest of code here

I wouldn't recommend that but I think it would do what you are lookin
for.

Keith
www.kjtfs.co

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

KJTFS wrote:
*I am not getting you either but I think one really ugly suggestio
would be something like this.


do until range("Whatever you want").value = "Your condition"

doevents

loop

''rest of code here

I wouldn't recommend that but I think it would do what you ar
looking for.

Keith
www.kjtfs.com *

actually that method doesn't use up as much resources as I thought, bu
it still has potential flaws.

keith
www.kjtfs.co

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

I'm sorry for being unclear. I really don't have a specific goal tha
I'm trying to achieve here, I'm just asking a question that occurred t
me as I was experimenting. Essentially I already know how to wait fo
a certain length of time, but what I want to know is what other option
are there for specifying how long I want it to wait.

Finally, I was unaware Message Boxes could not me modeless. I was jus
using that as an example of what I'm talking about.

Anyway, now that I think about it, there may not ever be a circumstanc
when this information may be necessary(I can't think of one that
couldn't use some other method to achieve the same ends), but I a
curious as to whether there is an an answer to my question or not.
Thanks again. - Piku

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