message without stopping execution?

Hi All,
Is there any method to display a message during a lengthy process to inform
the user on progress of the process without stopping execution as MsgBox
always does?
Stefi

what about something like:

http://www.cpearson.com/excel/Progress.htm

the LED class j back link on page is pretty funky in a geeky type of way.

and as a bonus you wont need to register any dlls

Dear Matt,

I just now reviewed the topics I was interested in. I hope you come back to
this topic, although quite a long time elapsed since your reply to my
question above (sending e-mail directly to your address failed).
I have found earlier http://www.cpearson.com/excel/Progress.htm page, I made
a test, and I found it not too convenient to use, but I missed the reference
to the "LED" type progress bar you attracted my attention to.
I just now downloaded and tested it (very nice), but I have to ask your help
to clearly understand your messages. You must forgive me for disturbing you
with such things, but my mother tongue is not English (in fact it's
Hungarian), and I don't know the meaning of words "funky" and "geeky", would
you give me some explanation or synonims (I didn't found these words even in
the largest English-Hungarian dictionary). Also I couldn't find out the
meaning of "class j" back link.

Regards,
Stefi

"MattShoreson” ezt Ã*rta:

>
> and as a bonus you wont need to register any dlls
>
>
> --
> MattShoreson
> ------------------------------------------------------------------------
> MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
> View this thread: http://www.excelforum.com/showthread...hreadid=380019
>
>

geeky - generally refers to someone who is not very athletic and is very
good with technical things such as computers. Bill Gates might be
considered geeky

funky - refers to something or someone that is popular because that
something or someone exhibits behavior or appearance that enjoys popular
acclaim. This is often associated with music and musicians. The term is
somewhat dated.

In the context:
"the LED class j back link on page is pretty funky in a geeky type of way."

Matt means the use of the LED is pretty impressive if you are impressed by
techical approaches/implementation.

--
Regards,
Tom Ogilvy

"Stefi" <Stefi@discussions.microsoft.com> wrote in message
news:4439FE79-CA73-4B10-B92E-85A8CA002A0C@microsoft.com...
> Dear Matt,
>
> I just now reviewed the topics I was interested in. I hope you come back
to
> this topic, although quite a long time elapsed since your reply to my
> question above (sending e-mail directly to your address failed).
> I have found earlier http://www.cpearson.com/excel/Progress.htm page, I
made
> a test, and I found it not too convenient to use, but I missed the
reference
> to the "LED" type progress bar you attracted my attention to.
> I just now downloaded and tested it (very nice), but I have to ask your
help
> to clearly understand your messages. You must forgive me for disturbing
you
> with such things, but my mother tongue is not English (in fact it's
> Hungarian), and I don't know the meaning of words "funky" and "geeky",
would
> you give me some explanation or synonims (I didn't found these words even
in
> the largest English-Hungarian dictionary). Also I couldn't find out the
> meaning of "class j" back link.
>
> Regards,
> Stefi
>
> "MattShoreson" ezt írta:
>
> >
> > and as a bonus you wont need to register any dlls
> >
> >
> > --
> > MattShoreson
> > ------------------------------------------------------------------------
> > MattShoreson's Profile:
http://www.excelforum.com/member.php...fo&userid=3472
> > View this thread:
http://www.excelforum.com/showthread...hreadid=380019
> >
> >

Is the problem that you don't want the code interrupted, or that you want
the MsgBox timed, and not depend upon a user responding. If the latter, use

Dim cTime As Long
Dim WSH As Object


Set WSH = CreateObject("WScript.Shell")
cTime = 10 ' 10 secs
Select Case WSH.Popup("Open an Excel file?!", cTime, "Question", _
vbOKCancel)
Case vbOK
MsgBox "You clicked OK"
Case vbCancel
MsgBox "You clicked Cancel"
Case -1
MsgBox "Timed out"
Case Else
End Select


--
HTH

Bob Phillips

"Stefi" <Stefi@discussions.microsoft.com> wrote in message
news:510F726B-7027-45C0-B641-0EC01A83F6AF@microsoft.com...
> Hi All,
> Is there any method to display a message during a lengthy process to
inform
> the user on progress of the process without stopping execution as MsgBox
> always does?
> Stefi
>

The latter was the case, and you gave me a good solution, thank you!
Nevertheless, Chris's suggestion Application.statusbar = "Message" is
simpler and sufficient in my case.
Regards,
Stefi


„Bob Phillips” ezt Ã*rta:

> Is the problem that you don't want the code interrupted, or that you want
> the MsgBox timed, and not depend upon a user responding. If the latter, use
>
> Dim cTime As Long
> Dim WSH As Object
>
>
> Set WSH = CreateObject("WScript.Shell")
> cTime = 10 ' 10 secs
> Select Case WSH.Popup("Open an Excel file?!", cTime, "Question", _
> vbOKCancel)
> Case vbOK
> MsgBox "You clicked OK"
> Case vbCancel
> MsgBox "You clicked Cancel"
> Case -1
> MsgBox "Timed out"
> Case Else
> End Select
>
>
> --
> HTH
>
> Bob Phillips
>
> "Stefi" <Stefi@discussions.microsoft.com> wrote in message
> news:510F726B-7027-45C0-B641-0EC01A83F6AF@microsoft.com...
> > Hi All,
> > Is there any method to display a message during a lengthy process to
> inform
> > the user on progress of the process without stopping execution as MsgBox
> > always does?
> > Stefi
> >
>
>
>

Would it be feasable to show the progess on a new sheet and periodically
switch back on the screen updating so that the user can see how the process
is updating.
Or can you use the Application.statusbar = "Message" to keep the user
informed?

Chris


"Stefi" <Stefi@discussions.microsoft.com> wrote in message
news:510F726B-7027-45C0-B641-0EC01A83F6AF@microsoft.com...
> Hi All,
> Is there any method to display a message during a lengthy process to
> inform
> the user on progress of the process without stopping execution as MsgBox
> always does?
> Stefi
>