Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello Again!
Can we pop out a message box as a reminder in excel when a certain condtion is triggered? Say A1=14-Sep-09 and B1=today(). Since, B1 has exceeded A1 so a message box as a reminder would pop out to alert. Thanks in advance. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You could put something like this in C1:
=IF(B1A1,"ALERT","") Not the same as a message box, but you get the idea - the alternative is to have a macro to do that for you. Hope this helps. Pete On Sep 15, 11:18*am, deepak wrote: Hello Again! Can we pop out a message box as a reminder in excel when a certain condtion is triggered? Say A1=14-Sep-09 and B1=today(). Since, B1 has exceeded A1 so a message box as a reminder would pop out to alert. Thanks in advance. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
With Worksheets("sheet1")
If .Range("B1").Value .Range("A1").Value Then Dim Res As Long Res = MsgBox("Reminder date has expired") Cancel = Res < 6 End If End With "deepak" wrote: Hello Again! Can we pop out a message box as a reminder in excel when a certain condtion is triggered? Say A1=14-Sep-09 and B1=today(). Since, B1 has exceeded A1 so a message box as a reminder would pop out to alert. Thanks in advance. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() HI Atishoo! The COde worked out. But the problem is the message box pops out again and again whenever there is a mouse click or TAB key is pressed. Is there a way that the message box pops out once and after we clik on ok it doesnot pop out? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I presume you must have put the sub in as a selection change event!
Id put it in to trigger on workbook open if that is an appropriate interval! Alternatively I think I would be tempted not to bother with the message box and use conditional format to turn the cell red when the date is superceeded. "deepak" wrote: HI Atishoo! The COde worked out. But the problem is the message box pops out again and again whenever there is a mouse click or TAB key is pressed. Is there a way that the message box pops out once and after we clik on ok it doesnot pop out? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why does the research box keep popping up? | Excel Discussion (Misc queries) | |||
How to stop message popping up before open the excel? | Excel Discussion (Misc queries) | |||
Clipboard Keeps Popping Up | Excel Discussion (Misc queries) | |||
"Cannot empty clipboard" message keeps popping up | Excel Discussion (Misc queries) | |||
broken links message still popping up | Excel Discussion (Misc queries) |