Macro that automatically runs a task when the workbook is opened. I want it to keep track and monitor the due date so that a Pop-up Reminder can be triggered. By the way, is it possible to display a image as well? Pls take a look at my attachment for better understanding.
View 14 RepliesEvery other Friday, I need to submit my biweekly work hour sheet to manager. For example, as 12/21/2007 is Friday and pay day, I need to submit my sheet. Next time is two weeks later, 1/4/08, and on.
12/21/07 is the first event.
I want to create a conditional format, or workbook events, or worksheet events to remind me on that Friday when I open that book or activate that sheet.
Our company has a delivery schedule, based on Excel 2003, WinXP. Is it possible to set up reminders (for next scheduled deliveries in a future?
View 2 Replies View RelatedI have got a workbook were I register our personnel.
In one sheet I have listed all our personnel and the dates their contracts expire.
Now this is what I am looking for:
Between 15 days and zero daysbefore someone's contract expires I want a pop-up telling me so. The person's name has to be in the pop-up.
I already got this
Private Sub Workbook_Open()
Dim c As Range
For Each c In Range("E2:E126")
If c > -15 And c < 0 Then MsgBox c.Offset(, -3), vbOKOnly + vbInformation, "LET OP! Einddatum contract nadert!"
Next
End Sub
I want the pop-up only when I open the workbook(not everytime I change something in the workbook)
In the workbook are more sheets, the code I have only works with one sheet.
I have a task follow-up sheet that I have made for my manager, where I need I have a column to set the date when the item is entered or the date the item was discussed in meeting, etc. Then I have an additional column with "due date", here I select the date that the task needs to be completed or the date when I should be getting feedback.
What I would like is to have a pop-up that opens and tells me which tasks are due today. This could happen as perhaps a check everytime that I open my Excel file.
I realize that a conditional formatting can be used, to change the color and highligh items that are due, but I really want a pop-up, this will really make my life easier and communication to my manager easier as well. Plus my manager could use this file without me present. Allowing for less meetings to discuss list.
I have uploaded the sheet that I have so far.
I have 4 employees who at the end of their shifts have to email me an excel workbook. The issue is that some of them are forgetful and after placing numerous post-it notes on their monitors one particular employees just forgets.
What i want to do if possible is that when the workbook gets closed, a pop-up window shows up on their screen reminding them to send the workbook. Even better would be if their was a button that they could click that would email the workbook as an attachment in the pop-up box.
Can i add th remainder my excel sheet or computer
View 1 Replies View RelatedColumn B on worksheet3 has a list of dates on it. Column C states set reminder. Column D states how many days before reminder i.e. 3, 7, 10, 14. If the reminder is set to on. Can VBA code be run when the Workbook (or worksheet) that checks this criteria then a pops up is displayed outlining the event (say Cell A)?
Also is it then possible to have on the pop up - Go to this event (i.e. row of data?)
I want to create an Excel file, which would create alerts/reminders based on dates specified in certain cells. I want to create a database of various events (for ex. Invested in XYZ stock at $10 per share) and put a date in one of the column of each record. I want excel to remind me to take a look at that record after, say, 30 days.
View 3 Replies View Relatedi would like to know if Excel offers a feature whereby reminders for instance to call a client will pop up when you open a particular file? I am not referring to the comments tags that one can insert. I am looking for a type of pop up screen function ?
View 6 Replies View RelatedThe following code is part of a reminder system I have, for birthdays, anniversaries, due dates, etc. The portion of the code works fine unless I change the offset col from 3 to 4. When the msgbox opens, while 3 is being used, it picks the information in the correct column. But when I change the 3 to a 4, it displays a blank, even though the next column has a number in it.
Works:
Code:
MsgBox c.Offset(0, 1) & " is in 1 days. They will be " & c.Offset(0, 3) & _
" years old.", , "Reminder for " & Month(c) & "/" & Day(c) & "/" & Year(dates)
Doesn't work:
Code:
MsgBox c.Offset(0, 1) & " is in 1 days. They will be " & c.Offset(0, 4) & _
" years old.", , "Reminder for " & Month(c) & "/" & Day(c) & "/" & Year(dates)
creating a MSG box to be placed at the start of the code, i need the following reminder statements written in the message box. If the answers to all statements is Yes then proceed running the code.
1. Is the value date in Sheet Summary Correct?
2. Is the workbook free of errors, check sheet "Errors"
3. Are all the graphs up to date?
Sub Save_File()
Application.ScreenUpdating = False
Sheets(Array("SUMMARY")).Copy
With ActiveWorkbook
.Sheets("SUMMARY").Cells.Copy
.Sheets("SUMMARY").Cells(1).PasteSpecial xlPasteValues
.SaveAs Filename:="S:Recsdata ReportingRec StatsSummary Stats" & Format(Date, "yyyy\MMM") & _
"Stat Summary_" & Format(Date, "dd-mm-yy") & ".xls"
.Close False
End With
Application.ScreenUpdating = True
End Sub
i have an excel sheet which contain some standardized chemicals with due date for standardization i want excel sheet sending email for outlook email list if the due date is older than today by 2 days. my work and i'm not clever using macros and VBA the file is attached
View 1 Replies View RelatedI've made a reminder but I want to add a picture along with that reminder msgbox which has poped up. How can I add that? If possible, can I add any song/sound (ping) with the same?
View 1 Replies View RelatedWould like to find a formula or macro which would automatically send an email to let me know when a date entered into the specific cell is coming close to expiration. e.g. if the date 01/05/2014 is entered into a cell i would like an email to be sent to me a month before the date is reached (01/04/2014).
Using Microsoft Excel 2010.
I am mostly using excel for simply data gathering and tracking. Require exact steps to be followed to accomplish the following:
Exact Requirement:
- Sending automated reminder mails if current date is 15 days prior to "TO" Date
- Sending automated reminder mails if current date is 10 days prior to "TO" Date
- Sending automated reminder mails if current date is 05 days prior to "TO" Date
- Sending automated reminder mails if current date is same as "TO" Date
Also, would be great if automated mails can be released if current date is 1 day past "TO" Date and showing "Overdue" in "Status" Column.
Below is sample data which gives an idea of the data kept and the requirement.
Exception ID
Requester
Email ID
System Name
[Code] ........
OS Detail- Windows 7
Microsoft Office - 2010
Microsoft Outlook- 2010