LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default help needed with msgbox

Hi NG.

I have a litte problem with my Macro. I would like to show a message-box
with vbyesno-buttons. This msgbox should stay open for about 5-10sec and
then close automatically.
In the msgbox I ask the user if he wants to open an Excel-file, and he can
answer "yes" or "no", as expected :)
But at the msgbox the macro stops and waits until the user clicks a button.
Now I don't want the macro to wait for eternity and go on after the
specified time. If the user didn't click a button in this time the
msgbox-result should be set to "yes" and the box should close.
I think an application.wait is not the right way, because excel waits before
the msg is shown or the msg appears before the wait command is active.
Or do I have to create a UserForm?

Has anyone an idea how to solve this?

Thanks in advance.

MB


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MsgBox CC Excel Discussion (Misc queries) 4 May 5th 06 05:45 PM
Msgbox Wildman Excel Worksheet Functions 1 April 26th 05 04:57 AM
Help with MsgBox... tjb Excel Worksheet Functions 3 December 29th 04 03:43 PM
MsgBox shasta[_5_] Excel Programming 4 April 13th 04 01:56 PM
MsgBox Ed Excel Programming 3 November 23rd 03 05:44 PM


All times are GMT +1. The time now is 07:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"