No video :(

Popup Reminder in Excel That Beeps and Speaks - Very Useful

Подписаться 97 тыс.

Просмотров 104 тыс.

50% 1

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:
officeinstruct...
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 (creativecommon...) Artist: incompetech.com/

Опубликовано:

28 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 148

@IvanCortinas_ES 3 года назад

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!!!

@ricksanchez6356 3 года назад

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!

@HotButteredCorn 10 месяцев назад

Thank you so much. "what" you teach is very useful. The "way" you teach has TREMENDOUS VALUE. Well done!!!!

@jamesthomas8249 3 года назад

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.

@madamedoobery 2 года назад

This has been an absolute gem of a timesaver. Thank you so much!

@user-my8cz3um8s Год назад

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.

@fidakhan8471 10 месяцев назад

Mr. Nabil Brilliant piece of Excel Coaching. May Allah Reward you Abundantly in every good way!!

@fadiamin705 2 дня назад

Excellent. Thank u a million.U r not only xel instuctor, but also u r xel professional. But just plz clarify how to set also for date

@Tommie_Rogers 3 года назад

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

@Up4Excel Год назад

Love it. A lot more simple than I expected and very useful indeed 👍

@Officeinstructor Год назад

Glad it was helpful!

@123mailashish 3 года назад

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

@morandoms3010 3 года назад

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?

@louellagalang9178 3 года назад

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.

@fadiamin705 2 дня назад

I think same way I try to add also date in addition to the time

@sanaokarian6169 6 месяцев назад

O my God.. Great Teacher Method... Love U sir .... Compliments from Pakistan

@Officeinstructor 6 месяцев назад

Thanks for watching

@amiyplacement7150 2 года назад

It's Brilliant, but can we set it on a particular date

@ruralheroes4183 5 дней назад

I vote for your questions. Please reply

@tsvs58 3 года назад

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

@jimfitch 3 года назад

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?

@aamirikramulhaq7902 2 года назад

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.?

@SyedMuzammilMahasanShahi 3 года назад

Brilliant work. Thanks for the share.

@Officeinstructor 3 года назад

You are most welcome Please Share and Subscribe

@SyedMuzammilMahasanShahi 3 года назад

@@Officeinstructor already did.

@nerenlakhraj5252 3 года назад

Thanks Nabil ... This is simply yet awesome reminder

@Officeinstructor 3 года назад

Glad you liked it!

@bickyboc 3 года назад

Thank you, a smooth explanation

@Officeinstructor 3 года назад

Glad it was helpful!

@wayneedmondson1065 3 года назад

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

@smartonlinetactics 2 года назад

Great video. Do you have similar tip for creating a popup for a date in a column when it becomes 90 days old?

@VernonFerreira Год назад

Hi. Can you use a date instead of a time for reminder.

@audreykhambule8926 3 года назад

Does the excel.file.need to.be opened in order to receive the pop up?

@natybiasetto3474 2 года назад

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!

@BrainsEatZombies35 3 года назад

Thanks for the code and explanation.

@Officeinstructor 3 года назад

You're welcome!

@mdks1012 2 года назад

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!

@neredusrinivas7360 Год назад

Thank you very much it was very much needy.

@meowmeowmeow5202 Месяц назад

Awesome. Can this work if I create one like this in PC and access it in mobile? Thank you.

@samermbayed9833 9 месяцев назад

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

@ruralheroes4183 19 дней назад

URGENT, PLEAE REPLY Hello, how will I set it for coming days But mate, you are excellent...wonderful it work for me, but would like to know how to set the alarm for Tuesday for example....

@ruralheroes4183 19 дней назад

URGENT, PLEAE REPLY😢 Hello, how will I set it for coming days But mate, you are excellent...wonderful it work for me, but would like to know how to set the alarm for Tuesday for example....

@pravinkumar1079 2 года назад

I am getting Compile error at When condition highlighting the "Time". Error says: Expected: list separator or ). Can someone help me please?

@vaidehiambavale9760 3 года назад

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.

@neerajkapilavai8378 2 года назад

This is not working for me, when I copied the exact code, it says compile error. Can you please help me solve the problem?

@ArmanKhan-iq3ji 2 года назад

Wow really it's very helpful to me ☺️ thnk u so much for make this help full video.

@miaantuerpia9070 2 года назад

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!

@cogwheelLearning 3 года назад

That's really ingenious!

@Officeinstructor 3 года назад

Thank you... best of luck with your tutorials

@zackcaruana3680 3 года назад

Amazing.. thank you! KEEP POSTING!!

@Officeinstructor 3 года назад

More to come!

@MbaekweCabana 2 года назад

I subscribed to your channel. See you next time Superman!!

@edwardoreyes4134 2 года назад

WOW.! very useful and and powerful.

@michaelsilva8236 4 месяца назад

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.

@user-px6bl1xg6l Год назад

very nice sir thank you for sharing

@paulajohnston3015 Год назад

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.

@chamundeshwari9035 10 месяцев назад

Great idea

@amaverick4953 3 года назад

Excellent sir. It's not less than a social service. Can I use more than 1 alarm ⏰ in a day?

@rabdu2002 3 года назад

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 .

@suhailnbd 3 года назад

Excellent

@Officeinstructor 3 года назад

Thank you so much 😀

@vincysigma 3 года назад

Wonderful Coding..Thankx

@Officeinstructor 3 года назад

Thanks Vincent

@tylerfoy8109 Год назад

Can I set this for multiple times? Example every hour?

@ShakuniMamaKaRishtedaar 2 года назад

Thank you very much. Can I input a reminder for a future date (say, 6 months in advance)?

@user-in1yp9vp2z Год назад

Hi, Please can you confirm what should I add/ change to allow reminders for specific dates please? Thank you!!!

@SAmiyan-bn2xw 2 года назад

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

@sayedali6236 2 года назад

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)

@ahead9645 2 года назад

Wonderful... I subscribed

@mohammedislam3541 2 года назад

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

@romulopallanan3529 Год назад

May I ask how to make countdowm timer with speak message in the remaining 2 minutes

@mdexcelpro8495 3 года назад

Hello sir nice and useful VBA can I create multiple Alarm in this VBA?

@lonzeelon2880 3 года назад

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?

@dineshna7902 3 года назад

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.

@user-ix8yf5ug4s Год назад

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

@cmanojkumar Год назад

Hello,, I want to add diff time slots at a time, what codes we have to use for that.

@ab-bc2gr 2 года назад

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?

@mohamedalsaqaf8693 3 года назад

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

@dolphinloh7018 3 года назад

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?

@paulajohnston3015 Год назад

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.

@margaretdaniels624 Год назад

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?

@sooraj9sharma 2 года назад

Can i put multiple reminder at same time

@lekhrajjangid8580 11 месяцев назад

will it work , if excel will close ?

@JulinaVictor Год назад

When i copy and paste the code i am getting error; this command will stop the debuger. kindly asssit

@xaniiu Год назад

For those having error messages with the quote boxes. delete the quote boxes and retype them manually

@ranjithranju1080 Год назад

Can we have create that remember for every 15 minutes for whole day without updating the timer again & again

@mandeepmanbajimaya7442 3 года назад

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

@him29103 Год назад

code is not working with me?

@BenDieselBasicAutomotive Год назад

Wow....

@deepakraghuvanshi835 3 года назад

My micro runs but doesn't either show notification neither speak. Why it is happening?

@apgsotcontacts5809 2 года назад

Can we put a snooz option in that please help!!

@sk12930 2 года назад

It is not working for me please help me. I pasted the code. Please help me

@tilinanirmal 3 года назад

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.

@iinsugiarti6112 Год назад

Mas apakah aplikasi ini bisa diatur untuk mengatiur di hari yang berbeda dan bulan yang berbeda dan di buat berulang.tolong info nya pak

@alinabazar6120 2 года назад

Do we have to keep the excel open

@swisscheese9653 3 года назад

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!!!

@tilinanirmal 3 года назад

Can I set a reminder and send to someone else ??

@rash9366 3 года назад

Amazing

@rajsankpal2941 2 года назад

Getting compile error Sub or function not defined Please help

@03564251790 Год назад

EXCELLENT

@Officeinstructor Год назад

Many thanks!

@Megarahuljha 2 года назад

How can i do it for multiple task or task list

@iZacq 6 месяцев назад

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 6 месяцев назад

Other than Outlook reminders, Not quite sure it exists. But the idea is great

@iZacq 6 месяцев назад

@@Officeinstructor Need something like WhatsApp or Signal or Telegram

@user-cr6xm5dd9r Год назад

how to enter date +time in the box

@shlokjain4493 2 года назад

this code isnt working now what is the problem ?]

@lexatambovski Год назад

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

@zimohassan9828 2 года назад

hi how i can create alarm icon

@geek07shrk 2 года назад

i dont know what i did wrong but it didnt work for me :(

@bsbalaguru 2 года назад

I am getting syntax error

@sonsoffishes1 7 месяцев назад

copy/paste, followed instructions. Doesn't work.

@swatithorat2900 3 года назад

Can I get code for the same?

@guweizhao3430 3 года назад

how to set up reminder doing something at a specific time every day automatically?

@Officeinstructor 3 года назад

That's a different project... I may create a tutorial on that in the future.

@PeaceandTranquility. 3 года назад

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?