Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MsgBox alerts
I have an excel workbook that at certain key dates (for example on the 5th
Feb and the 10th March etc etc) would like to have Alert Box or MsgBox pop up by way of a reminder to complete a certain task (this would take the shape of reviewing another part of the workbook for instance) Is this possible? I have started by listing all the years dates in one tab vertically and then writing the alert information in the adjacent cell, then using a =today() was hoping to link the two together€¦ but have come to a dead end on how to do this. Many thanks for any help and I hope this makes some sense€¦ Andy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MsgBox alerts
Andy,
although there are several solutions, you can start with Conditional Formatting. Select both columns, Format|Conditional Formating... Use Formula Is (instead of Cell Value Is) And enter the following formula =$A1=TODAY() And choose a format to highlight the cells to taste. On the automation front, as a first step you can put an event macro Private Sub Workbook_Open() Sheets("Unfinished Tasks").Activate End Sub This will be activated any time you open the workbook and bring up the specified sheet. To install: 1. Change the part within the quotes to the name of the sheet. 2. Alt+F11 for the VBA development environment 3. At the top-left of the window you see the Project Explorer window. Double-click on the ThisWorkbook icon. 4. Paste the code. From this point on, every time you open the workbook it will take you to the task list first. Maybe you can have an additional column with a 0/1 or yes/no if the task is completed. If you put this in column C:C then the formula for conditional formatting would be: =AND($A1=TODAY(), $C1=0) or =AND($A1=TODAY(), $C1="no") HTH Kostis Vezerides |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
MsgBox compile error in Excell | Excel Discussion (Misc queries) | |||
MsgBox with condition and showing details | Excel Worksheet Functions | |||
display cell value in msgbox formatted as % | Excel Discussion (Misc queries) | |||
Msgbox | Excel Worksheet Functions |