Hi,
Thanks for reading my post.
At the end of a macro I would like to have a speech speak followed by a message box.
If the msgbox is not acknowledged I would like the speech speak to be repeated every 2 minutes.
I have enclosed my attempt but it is not working.
Any help is much appreciated.
Thanks and regards john
Please Login or Register to view this content.
The MsgBox by default is displayed Modal. That means it refuses to allow anything else to occur until it is given an answer (Yes/No buttons, Cancel, etc.).
You can get around the Modal property by using a call to the API. This resource provides an excellent example (untested here) : http://www.tek-tips.com/faqs.cfm?fid=4699
An alternative to the above route would be to create a UserForm that looks like a MsgBox (and provides alot more flexibility for you) and load the UserForm Modeless.
The code you showed here does not compile because of your syntax in the Speak line.
Once we fix that you have three problems to solve. First, make Repeat recursive so it speaks the line then reschedules itself, rather than having the caller do that. Second, MsgBox is a modal dialog box. When the message box is show, no code will run. You have to create a UserForm that is modeless. When the user clicks OK, the userform cancels the timer. Third, you have to have a line of code to cancel the next scheduled reminder.
I have attached an example.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Thanks for your responses.
I will review and revert.
Regards john
Hi,
I reviewed the 3 subs.
You correctly stated that the solution lies in a user form message box as a message box locks the code until their is a response.
The only change I made was putting the call sub repeat after the user form message box.
Really appreciate your response, thank you very much.
Kindest regards john
Hi
Just a minor addition here.. I had not seen the Application.Speech Method before…
I had been given a “Speech Application Programming Interface” thingy in a Thread. ( I do not know if it is related somehow to the Application.Speech).
It is never a bad idea in programming to have an alternative Method, IMO, so here is the two Methods together just for future reference.
AlanPlease Login or Register to view this content.
Last edited by Doc.AElstein; 01-14-2018 at 03:26 AM.
Hi
Here is a possible additional solution to this Thread.
My start point was a solution based on the suggestion in Post #2, the “non Modal MsgBox”
I was interested in learning this possibility and in doing so tried to achieve a solution to this Thread.
Unfortunately it did not work. The stumbling block remains that the code ( and most other things in the Excel worksheet) will “wait” until the message box is closed.
However in the course of the experimenting I came across a solution that works involving a “API call” to what appears the most fundamental message box standard Windows code.
The solution is not as good as the full complete UserForm solution already given in Post #3
It still does not let much more go on whilst the Msgbox is open . But it achieves a recurring message box and spoken message which only stops when the User closes the message box.
Explanation of the general idea and code development is here:
https://www.excelforum.com/developme...ml#post4822070
The final code is here:
https://www.excelforum.com/developme...ml#post4822413
Last edited by Doc.AElstein; 01-16-2018 at 05:11 PM.
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks