How to create notifications or reminders in Excel with VBA
HTML-код
- Опубликовано: 3 фев 2016
- This is a revised version of my earlier video - how to create notifications or reminders in Excel with VBA.
All details available here: www.exceltrainingvideos.com/ho...
Thank you for creating this video and the subsequent video tutorial about sending email reminders automatically. Your videos are very informative and helpful!
thanks for sharing and we hope you will be inspiring us with your innovative thinking
very simple and very good
Thank you very much for posting this video! In the tutorial, you mentioned that you have a video explaining the VBA code as shown. I looked through your channel and could not find it. Could you please direct me to your video? Thanks again for these wonderfully detailed instructions!
www.exceltrainingvideos.com/how-to-create-notifications-in-excel-with-vba-revisited/
It's a good idea to read the description accompanying the video.
can you help to use in excel 2016 date reminder (not specific row automatically find) or select multiple row in single sheet popup before 30 days including month and year.
for example'
Today date 01/06/2016 to 31/07/2016. must be reminder 01/06/2016.
please help me
this is very nice. thanks.
only thing i'll change is to call the macro when you open the file. That way you do not need to click buttons.
You can even call it when you save, if you intend on adding new data.
+RL S ruclips.net/video/BiDfI4-kngw/видео.html
Dinesh Kumar Takyar
Dinesh Kumar Takyar q
Dinesh Kumar Takyar
Hello Sir, Really its works i just want one thing in subject can we take value of card number thats in our 1st row
Use the Range or Cells property. This link will help: www.exceltrainingvideos.com/tag/how-to-send-email-through-outlook-at-specific-time-using-vba/
Or search www.exceltrainingvideos.com
Thanks for posting this video, I have One query like if I want to send a reminder on a weekly or monthly basis then how we can do that, and secondly, if we want to remind only those people who don't fill the form or excel tracker.
The following VBA tutes will guide:
www.exceltrainingvideos.com/tag/auto-acknowledge-receipt-of-mail-with-a-unique-tracking-number/
www.exceltrainingvideos.com/tag/how-to-send-email-through-outlook-at-specific-time-using-vba/
www.exceltrainingvideos.com/how-to-send-email-reminder-automatically-from-excel-worksheet-using-vba/
hello, and if i want to reminder when , exsample: on cell B2 have this number 500, and i want alert popup when i have 200 in cell B2. thank's best regards
This link will help solve the problem: www.exceltrainingvideos.com/if-else-function-using-vba-in-excel/
Dear Dinesh Kumar Takyar; thank you and congratulate for your videos, they are very beneficial for thousands of people. Please, you could make a macro that uses the windows dialer to make calls phone from Excel; can record the start of the call, the duration of the call and record the call. Do you think it's possible?
+JD21O Sounds exciting. Let me see.
Dear sir thanks for sharing such a useful videos, Sir can you please me help how to create a macro, When any changes are made in excel sheet, It should send notification via email, Please help me.
please advised, always error and there is a statement "run-time error '424' object required.
and Debug shows lastrow = Sheet1.Cells(Row.Count, 1).End(xlUp).Row
Check the code again.
I same with him, get error in that area
Hello !Thanks to userform i would like to insert some informations in a board. I would like to duplicate this board each week on a new worksheet. If i want to insert informations the 04/04/2016 , they will be add in the board and columns related.
Is it possible to realize a video.?
Your videos are very helpfull ! I am student in civil engineering and its very helpfull for my project ! thanks very much
The board has five columns, each columns represent one day in a week
Lucas REBILLARD
Lucas REBILLARD
Lucas REBILLARD
also, is there a way to send reminder only to certain customers, not to everyone? Thanks so much
Yes. What have you tried?
I haven't really tried, to be honest, VBA is very new to me, so I just go on a step-by-step basis at this stage :)
This link will help: www.exceltrainingvideos.com/excel-vba/excel-2003-vba/
is there a way to set the reminder between certain days, say between 3 days before it's due and 3 days past due?
Thanks :)
Yes.
would you mind explaining how? Thanks
hi, i did what you have shown on the video but i received "Syntax Error". What does this mean?
A syntax error is an error in the syntax of a coding or programming language, entered by a programmer. Syntax errors are caught by a software program called a compiler, and the programmer must fix them before the program is compiled and then run.
It is helpful to think about the usual causes of syntax errors - either a programmer makes a typographical error, or forgets the format or sequence of some word or command.
i did what exactly is in the video, but all my reminder date field is highlighted. where there is so many days before expiration please advice, i need to have a reminder 10 days before expiration
This link will help: www.exceltrainingvideos.com/how-to-create-notifications-in-excel-with-vba-revisited/
For 10 days change 3 to 10.
Dear Sir, I have made the exact excel sheet and coed exactly the same way, but when i run the macro, the reminder cell gets populated with the reminder due date value, instead of it becoming blank. example, when i put payment date as 20-01-2020, and set reminder as 3 days, my reminder cell is becoming red in color and the date 17-01-2020 gets populated. Please help. Thank you
Just checked. The code works fine. Try using dates in this format as a trial: 04-Dec-2019.
I want the same method for hours then how we can do that please reply
Instead of 'dates' you can try 'time'.
how to create an audible reminder for VBA excel?
This VBA lesson will help: www.exceltrainingvideos.com/tag/automation-using-excel-vba/
I followed your instructions, but it seems the one you're showing has syntax error. Please send me the working syntax. I also noticed that your video is somewhat edited when you tried to run the compiler. I assume you encountered the same error but you didn't show us the working one. Your help is needed. Thank you!
It's a good idea to read the description accompanying the video: www.exceltrainingvideos.com/how-to-create-notifications-in-excel-with-vba-revisited/
Please don't assume things. Verify the facts.
I tired reading the description and I even copied your code. There's one difference as well from the video and the code you stated on the description: "If Cells(i, 3) = Date Then" Here it's "equals" on the video it's "difference'. It's confusing. I tried both but the compiler is just saying "syntax error" (no codes). Can you share the actual code that can send an email depending on the value of the cell? How can I do it within a range of cells? Thank you in advance.
I've pointed out many times that copy and paste doesn't work. You'll have to carefully check the pasted code for errors.
it works first i tried to copy and paste it it was giving syntax error after that i typed in with keyboard then its gone,, try this way.
i am new in this Vba, Getting error 13
This link will guide: www.exceltrainingvideos.com/how-to-create-notifications-in-excel-with-vba-revisited/
Or search www.exceltrainingvideos.com
I am getting "Compile error Syntax error"
Check your code because the answer lies in the message!
I have checked it, but still does not work. I have taken from your website. If I would have your email, I could have email you and check. :(
Same thing can b done by using Vlookup and conditional formatting. That will do the same but without running anything aur pressing any button. Then Y v need do this mess
You're missing a very important point. Think!
I have written the same codes, but not getting the output...
Sub createNotifications()
Dim a As Long, lastrow As Long
lastrow = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To lastrow
Cells(i, 3).Value = Cells(i, 2) - 3
If Cells(i, 3) - Date Then
Cells(i, 3).Interior.ColorIndex = 3
Cells(i, 3).Font.ColorIndex = 2
Cells(i, 4).Value = "Send Reminder"
Else
Cells(i, 3).Font.colorindes = vbbalck
Cells(i, 3).Interior.ColorIndex = 2
Cells(i, 3).Value = ""
End If
Next
End Sub
Did you activate the 'Outlook' library?
@@Exceltrainingvideos no I have not... is that the reason I am not able execute those commands?
Most likely.
I want the same method for hours then how we can do that please reply
Try using TIME.