i have the below code, if someone can help me modify the code with a timer to disaapear by defautl if no user input is received after a few seconds (per say 10 seconds).
![]()
Please Login or Register to view this content.
i have the below code, if someone can help me modify the code with a timer to disaapear by defautl if no user input is received after a few seconds (per say 10 seconds).
![]()
Please Login or Register to view this content.
Last edited by chubbychub; 04-30-2024 at 12:58 PM.
To do that, you need to create a userform that you can show with your message and with commanbuttons to set the response: show the userform and schedule a macro using the ontime method to hide the userform if it hasn't already been replied to.
Bernie Deitrick
Excel MVP 2000-2010
Hi, try this, timeout is 5 sec
![]()
Please Login or Register to view this content.
thanks for the replies, danny i get error 'Findwindow' typemismatch error on the debugger
sorry, I think Findwindow is not necessary here
![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Last edited by daboho; 04-30-2024 at 03:13 PM.
daboho, thanks for the reply, but how come yes or no buttons dont show up? only, ok buttons shows , thenmessagebox disappears after 5 seconds, but can you please code with a 'yes ' and 'no' button and wait for 5 seconds, if no user input, then disappear? thank you
Perhab untest
![]()
Please Login or Register to view this content.
Last edited by daboho; 04-30-2024 at 04:50 PM.
![]()
"Presh Star Who has help you *For Add Reputation!! And mark case as Solve"
i get object variable or block variable not set error, and thank you for your attention and your help.
Last edited by chubbychub; 04-30-2024 at 05:43 PM.
Does this work for you?
![]()
Please Login or Register to view this content.
Just be aware that the shell.popup method is notoriously unreliable.
Everyone who confuses correlation and causation ends up dead.
I've heard it said but have never experienced any issues with it.Just be aware that the shell.popup method is notoriously unreliable.
I have. Even on the same machine I've found it unreliable.
In what way?
It didn't dismiss itself.
Maybe I've just been lucky.
Or I've been unlucky! Anyway, once bitten, and all that.![]()
Bytemarks! it does work for me, perfectly. Thank you! thank you all for the help.
You're welcome. Good to hear.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks