Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MsgBox | Excel Discussion (Misc queries) | |||
Msgbox | Excel Worksheet Functions | |||
Help with MsgBox... | Excel Worksheet Functions | |||
MsgBox | Excel Programming | |||
MsgBox | Excel Programming |