Popup Reminder in Excel That Beeps and Speaks - Very Useful
If you spend long hours on Excel then this project will be extremely useful for you: It will enable you to create a Reminder that pops up on time, reads a custom message aloud and displays the custom message in a message box.
You can either follow along and create it from scratch , or simply copy the code and paste it into your visual basic editor, without ANY Knowledge of VBA.
You can copy the code from the link here below:
officeinstructor.com/create-a...
You can Master Excel by learning clever techniques that combine Data validation with almost every tool in Excel. My new Book :
*************** Data Validation a back door to Master Excel ********************* *************************** is Now Available at ****************************
************************ www.Amazon.com *******************************
************************ www.Amazon.com *******************************
My New Book Is Now available on Amazon. It is much more than the Data Validation you know! Through Data Validation I Cover over 60 different Functions, Charts, Slicers, Pivot Tables, Conditional Formatting, Macros, Power Query, Dynamic Arrays, DAX, Data Model and VBA.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Booking a Corporate Training (at Client Site or Remotely)
*********************** Book A Corporate Training ************************ ***************************** With Nabil Mourad ************************
************************ www.OfficeInstructor.com **********************
************************ www.OfficeInstructor.com *********************** ##################################################### ****************************************************************************
Music Credit: News Theme by Kevin MacLeod is licensed under a Creative Commons Attribution license (creativecommons.org/licenses/...) Artist: incompetech.com/
Пікірлер: 143
Brilliant, concise, practical, pedagogical = Nabil !!
@Officeinstructor
3 жыл бұрын
Thank you so much for the extremely nice comment my friend... Totally appreciated Happy New Year Ivan Cortinas
@IvanCortinas_ES
3 жыл бұрын
@@Officeinstructor Thank you Nabil. Happy new year my friend!!!
Thank you so much. "what" you teach is very useful. The "way" you teach has TREMENDOUS VALUE. Well done!!!!
This has been an absolute gem of a timesaver. Thank you so much!
I love this. I can't believe how simple the VBA was for something like this. I was expecting to see pages and pages of code. Thank you so much.
@Officeinstructor
3 жыл бұрын
Glad it helped!
Very Informative video! Your explanation goes well & easy to catch up. It would be highly appreciated if u will make another video for the date reminder in excel.
Brilliant Nabil. Thanks for your service to us!
@Officeinstructor
3 жыл бұрын
I'm glad you liked it Venkat. By the way I would like to invite you to join a FREE Excel Master Class that I will be delivering for 90 minutes on 27 January 2021 at 5:30 PM (EST) . It is a Free event but requires registration by clicking on the link : www.meetup.com/MSExcelToronto/events/275407502 Please share this event on your social platforms
Thanks for this tip. Much appreciated. Have been looking for something like this for some time now, to remind me and my students when the break is about to start/end. I share a lot of your training with my fellow trainers and my students and also suggest they subscribe.
@Officeinstructor
3 жыл бұрын
Glad it was helpful! Thomas. Please keep sharing for the benefit to spread
Love it. A lot more simple than I expected and very useful indeed 👍
@Officeinstructor
Жыл бұрын
Glad it was helpful!
Hi Nabil. Thanks for this code example and exercise to kick off 2021. Excellent.. and fun! Thanks for sharing :)) Thumbs up and Happy New Year!!
@Officeinstructor
3 жыл бұрын
Happy new year to you too Wayne...and thanks for the nice comment and continuous support
With Mr. Nabil it is always, best is yet to come. Cool it was!@@!
@Officeinstructor
3 жыл бұрын
Thank you Ashish Gupta... Stay tuned for the Best
Alhamdulillah Mr Nabil! Jazakallah may Allah rewards you abundantly for your brilliant work! I have tested today 16.7.23, it really works! Guys, you need to delete some of the texts Mr Nabil added into the VBA script in his website, to match the one you saw in the video. Some double apostrophe may need to change to your keyboard type of double apostrophe. after i have tried those, it had work perfectly! Cant say enough thanks to Mr Nabil. wassalam.
Thanks Nabil ... This is simply yet awesome reminder
@Officeinstructor
3 жыл бұрын
Glad you liked it!
Mr. Nabil Brilliant piece of Excel Coaching. May Allah Reward you Abundantly in every good way!!
What do I need to do if I want the time and message input to be via cells in an excel sheet instead of the input boxes? Your videos are extremely professional and high quality btw, Thank you! EDIT: Okay, I figured it out....BUT now I'm having the issue of the script not running after I run a different macro script in the same excel. Do I have to run the macro every single time after I run a different macro, IS there a way around this?
Put the code in the personal sheet. Works great on all my workbook. Learned something today from your code too. Thanks for the effort.
@Officeinstructor
3 жыл бұрын
Awesome, thank you James.
Thank you for introduction to speech feature. I did not know that it existed. Very neat feature.
@Officeinstructor
3 жыл бұрын
Then here is a bonus my friend: Do you know there is a "Speak" command that you can add to word Ribbon or QAT without any coding?
Thank you, a smooth explanation
@Officeinstructor
3 жыл бұрын
Glad it was helpful!
Amazing.. thank you! KEEP POSTING!!
@Officeinstructor
3 жыл бұрын
More to come!
Amazing! I would like to ask if how to make the alarm longer? Like for example (2:00-2:05) for 5 mins? And is there a way to set an reminder for multiple times at the same time? Hope for your response. Thank you!
WOW.! very useful and and powerful.
Thanks for the code and explanation.
@Officeinstructor
3 жыл бұрын
You're welcome!
Dear Mr. Nabil, thanks a lot for your effort & fantastic tutorial video . I followed the steps but I received this message. Can't run the macro ...... in spite of the macro is enabled. what I have to do? also please could we use it for next day or any future day .
Thank you very much it was very much needy.
Great video. Do you have similar tip for creating a popup for a date in a column when it becomes 90 days old?
Thank you very much. Can I input a reminder for a future date (say, 6 months in advance)?
Wow really it's very helpful to me ☺️ thnk u so much for make this help full video.
Brilliant work. Thanks for the share.
@Officeinstructor
3 жыл бұрын
You are most welcome Please Share and Subscribe
@SyedMuzammilMahasanShahi
3 жыл бұрын
@@Officeinstructor already did.
Wonderful... I subscribed
Hi can you please share the similar video for creating a due date reminder with Speech and msg box. The current video is very useful and I was successful in creating the alarm Popup reminder.
Thank you Nabil!!! Love it! I’m wondering what should I add/ change on the macro to allow reminders for specific dates please? Thank you!!!
@8HChris
2 жыл бұрын
Yes, that would be great!
Thanks so much Nabil for this lovely and detailed tutorial. Its really helpful. One more thing, your voice is too good 😊 How to set this picture pop like you did? Any coding and tutorial please? Thank you!
I subscribed to your channel. See you next time Superman!!
Nabil. Great work man. Can you please make a video on expiration dates of any thing to remind us before 15 days of due date.?
Thanks for sharing! How can I make the message window to pop up again after few minutes if the user closed it and pressed OK? Or two options (Snooz & Close)
That's really ingenious!
@Officeinstructor
3 жыл бұрын
Thank you... best of luck with your tutorials
Great idea
Hi Nabil, it did pop up when i click on the icon, but it didnt react the way you shown, kindly advise if there is anything i supposed to do before i run this macro in a new excel spreadsheet. Also may i know if it can set date together with time? Or it can only used for the actual day or may a way to run by the listed time & date frame, instead of only for 1 reminder for each clicking?
O my God.. Great Teacher Method... Love U sir .... Compliments from Pakistan
@Officeinstructor
5 ай бұрын
Thanks for watching
Hello nabil very useful tool. Thank you so much. I have problem with opening xl file display message "cannot run the macro . The macro may not be available in this workobook or all macros may be disabled" I Save as file as " Excel Macro-Enabled Workbook" Even I make enable "Trust Center" also. Please can u solve this
Hi, Please can you confirm what should I add/ change to allow reminders for specific dates please? Thank you!!!
very nice sir thank you for sharing
Does the excel.file.need to.be opened in order to receive the pop up?
Amazing
Hello,, I want to add diff time slots at a time, what codes we have to use for that.
Wonderful Coding..Thankx
@Officeinstructor
3 жыл бұрын
Thanks Vincent
I have wanted to do this for ages and it's awesome. However my macro always has issues and I have no idea how to solve it? Thanks and I will keep trying until I get it right or find someone to help me. Please tell me where to find and copy your script to see if that works. Thanks again.
Hi, Nabel first let me thank you for sharing your PRECIOUS knowledge may Allah bless you with more knowledge well i managed to reach all the steps shown in your video when i open and try to fix ALARAM in excel 2019 i get a pop message - Cannot run the macro Book 1 Popupreminder. The macro may not be available in this workbook or all macros may be disabled. please advice how should i short out this problem. thanks
Hello sir nice and useful VBA can I create multiple Alarm in this VBA?
Awesome. Can this work if I create one like this in PC and access it in mobile? Thank you.
What about adding a Date too? I need a reminder 4 times a year to carry out a specific task, each on a different date. The Message could give example of Date&Time format required. e.g. "What Date & Time would you like the reminder message to pop up? Example: 12/07/22 9:00 AM This is great but wondering how I d=can specify a date too?
Hi. Can you use a date instead of a time for reminder.
Excellent
@Officeinstructor
3 жыл бұрын
Thank you so much 😀
Excellent sir. It's not less than a social service. Can I use more than 1 alarm ⏰ in a day?
I am getting Compile error at When condition highlighting the "Time". Error says: Expected: list separator or ). Can someone help me please?
It's Brilliant, but can we set it on a particular date
Can i put multiple reminder at same time
Can we put a snooz option in that please help!!
How can i do it for multiple task or task list
Just saw it and great, How would I be able to add multiple reminders to 1 sheet. I need to add a reminder for column a and column b but when I click the reminder, it shows the previous one and cancels it.
Excellent method. Can we make a pop-up reminder for a DATE and TIME? For example: to remind me to may my insurance on a specific date and time
Do we have to keep the excel open
Can I set a reminder and send to someone else ??
This is not working for me, when I copied the exact code, it says compile error. Can you please help me solve the problem?
I am new to VBA and struggling! What do I do to get rid of "identifier under cursor not recognised"? Sub PopupReminder() then "Message InputBox". Driving me nuts! Thanks any help would be appreciated.
May I ask how to make countdowm timer with speak message in the remaining 2 minutes
hi how i can create alarm icon
Can I set this for multiple times? Example every hour?
Excellent Nabil, your lessons are always out of the box 😉👌🏼 My question is can I leave a pop-up message to a file which I am sharing with other users? For example there is a dashboard report which I am sharing with 30 people on biweekly basis and I want to remind them to do something on a specific time and date so when they open the file after this time they'll get the message
@Officeinstructor
3 жыл бұрын
Thanks Mohamed for the comment and glad you like my videos. To answer your question: Yes you can but the code needs extensive modifications.
@mohamedalsaqaf8693
3 жыл бұрын
Hi Nabil Thanks for your prompt reply If you could do it for us this will really spread viral as I am sure many users would like to have such feature
@rajsankpal2941
2 жыл бұрын
@@Officeinstructor getting error as compile error Sun Or function not defined
Can the font of message or whole message be formatted to display large visibility.
@Officeinstructor
3 жыл бұрын
The font and font size of MsgBox/InputBox are determined by your system and display settings, they cannot be changed by VBA. So you'd have to create your own dialog as a userform.
Can I get code for the same?
Wow....
Hi Nabil sir, I tried using your macro. But I faced an issue. The pop up comes immediately and not in the time I provided. I tried saving macro in the module of the personal workbook where I have stored other macros. How can pop up come in the input time?
@Officeinstructor
3 жыл бұрын
My only advice is to review and compare the code meticulously to mine. good Luck
will it work , if excel will close ?
its giving an error can not use macro the macro may not be available in this workbook or all macros may be disabled. i have already enabled the macros please help me
Getting compile error Sub or function not defined Please help
Hi I copied the code and pasted as instructed however the two lines of code below is in red and both lines has the error Compile error: Expected: list separator or ) When = InputBox(“What time would you like the reminder message to Popup?”) Message = InputBox(“Please enter the reminder message”) How do I fix it?
For those having error messages with the quote boxes. delete the quote boxes and retype them manually
Can I add a task - set reminder- and email to someone ?
@Officeinstructor
3 жыл бұрын
That's a whole project by itself not a simple question that requires a short answer. But yes you can.
Mas apakah aplikasi ini bisa diatur untuk mengatiur di hari yang berbeda dan bulan yang berbeda dan di buat berulang.tolong info nya pak
My micro runs but doesn't either show notification neither speak. Why it is happening?
this code isnt working now what is the problem ?]
how to set up reminder doing something at a specific time every day automatically?
@Officeinstructor
2 жыл бұрын
That's a different project... I may create a tutorial on that in the future.
It is not working for me please help me. I pasted the code. Please help me
code is not working with me?
How about if you want a specific date reminder?
@Officeinstructor
3 жыл бұрын
Code needs to be customized
@gamingwithtacod575
2 жыл бұрын
There’s a notification “cannot run the macro ??????. The macro may not be available in this workbook or all macros maybe disabled. Please help
@dimdiotik6896
Жыл бұрын
@@Officeinstructor can you do a tutorial of it?
In Windows 11 is there a Mesg App for REMINDER- If i send a Mesg to my Computer it will Pop-up when i start my PC & Remind me, like a messaging application
@Officeinstructor
5 ай бұрын
Other than Outlook reminders, Not quite sure it exists. But the idea is great
@iZacq
5 ай бұрын
@@Officeinstructor Need something like WhatsApp or Signal or Telegram
When i copy and paste the code i am getting error; this command will stop the debuger. kindly asssit
Can we have create that remember for every 15 minutes for whole day without updating the timer again & again
how to enter date +time in the box
I received an error message that said "Compile Error, Argument not Optional" and the Sub PopupReminder() was highlighted yellow. Can anyone help solve my issue?
@rtopno1
3 жыл бұрын
i got the same. any solutions?
I am getting syntax error
Cant you select what date you want to set an appointment for?
@Officeinstructor
3 жыл бұрын
That would be a different code
@natybiasetto3474
2 жыл бұрын
@@Officeinstructor thank you Nabil!!! Loved it. Do you have a video about setting a code to a specific date please? Couldn’t find it on your channel. Thank you very much!!!
How to save that code??
@Officeinstructor
2 жыл бұрын
Right click on the module in the project explorer and select Export
if you're receiving some compilation errors in VBA you should replace quotes from this -- “ -- to normal -- " -- everywhere in the code and also delete every comment after -- ' -- and it should work
i dont know what i did wrong but it didnt work for me :(
copy/paste, followed instructions. Doesn't work.
Didn't work :( it is throwing errors
So no help on those of us who are getting errors? there are at least 5 other people who have asked.
Please speak हिंदी
EXCELLENT
@Officeinstructor
Жыл бұрын
Many thanks!