View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Popping out Message Box!

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.